====== Best Pratices ======

<WRAP round tip>

Vigilens Reporting is the ideal tool for **operational reporting**. In this context, everything should be done so that the end user quickly has the information he needs, only the information he needs.
</WRAP>


===== Limit processing time =====
The processing time must be short:

  * Less than **25 seconds** is ideal
  * **100 seconds** is a big maximum before the user moves on

To minimize response times:

  * Use the key fields for [[en:v8_0_0:designer:menus:accueil:nouvellerequete:jointures|joins]].
  * Use [[en:v8_0_0:designer:menus:accueil:nouvellerequete:jointures#standard joins|standard joins]]. #TBC
  * Use the key fields for the [[en:v8_0_0:designer:menus:accueil:nouvellerequete:criteres|selection criteria]].\\ {{:v8_0_0:howto:pasted:20200701-154225.png?nolink}}
  * Allow wildcards ("*") of the interactive selection [[en:v8_0_0:designer:menus:accueil:nouvellerequete:parametres|parameters]] **only if required**.
  * [[en:v8_0_0:designer:menus:accueil:nouvellerequete:start#time_out|Set a maximum duration of execution]] if there is a risk of significant duration.

<WRAP round tip>
If the extraction absolutely requires a duration incompatible with interactivity, use the scheduled execution.
</WRAP>


===== Readability =====

The mass of data returned must be easy to grasp:
  * 5 to 10 columns are recommended.
  * 50 columns are a big maximum.
  * 10 to 25 lines are the ideal number.
  * 100 lines is a maximum.

To minimize the number of data displayed:
  * Favor interactive [[en:v8_0_0:designer:menus:accueil:nouvellerequete:criteres|data selections]] using [[en:v8_0_0:designer:menus:accueil:nouvellerequete:parametres|parameters]].
  * Use the grouping functions.\\ {{:en:v8_0_0:howto:pasted:20200707-152541.png?nolink}}
  * Use the [[en:v8_0_0:designer:menus:accueil:nouvellerequete:requeteliee|linked queries]]: from the most synthetic to the most detailed vision ("drill down").