meta data for this page
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
en:v8_0_0:howto:bestpractices [2020/07/07 14:29] sylvainair |
en:v8_0_0:howto:bestpractices [2020/07/07 16:14] (current) sylvainair [Limit processing time] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ====== 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 ===== | ===== Readability ===== | ||
| Line 8: | Line 35: | ||
| To minimize the number of data displayed: | To minimize the number of data displayed: | ||
| - | * Favor interactive data selections using parameters. | + | * 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. | + | * Use the grouping functions.\\ {{:en:v8_0_0:howto:pasted:20200707-152541.png?nolink}} |
| - | * Use the related queries: from the most synthetic to the most detailed vision ("drill down"). | + | * Use the [[en:v8_0_0:designer:menus:accueil:nouvellerequete:requeteliee|linked queries]]: from the most synthetic to the most detailed vision ("drill down"). |
| - | + | ||
| - | [[v8_0_0:designer:menus:accueil:nouvellerequete:criteres|sélections de données]] interactives en utilisant des [[v8_0_0:designer:menus:accueil:nouvellerequete:parametres|paramètres]]. | + | |
| - | * Utilisez les fonctions de regroupement.\\ {{:v8_0_0:howto:pasted:20200701-160315.png?nolink}} | + | |
| - | * Utilisez les [[v8_0_0:designer:menus:accueil:nouvellerequete:requeteliee|requêtes liées]] : de la vision la plus synthétique vers la plus détaillée ("drill down"). | + | |