meta data for this page
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
en:v8_0_0:howto:bestpractices [2020/07/07 14:26] sylvainair created |
en:v8_0_0:howto:bestpractices [2020/07/07 16:14] (current) sylvainair [Limit processing time] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ===== Lisibilité ===== | + | ====== Best Pratices ====== |
| - | La masse de données restituées doit pouvoir être facilement appréhendée: | + | <WRAP round tip> |
| - | * 5 à 10 colonnes sont recommandés. | + | |
| - | * 50 colonnes sont un grand maximum. | + | |
| - | * 10 à 25 lignes sont le nombre idéal. | + | |
| - | * 100 lignes sont un maximum. | + | |
| - | Pour minimiser le nombre de données affichées: | + | 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. |
| - | * Favorisez les [[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]]. | + | </WRAP> |
| - | * 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"). | + | |
| + | ===== 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"). | ||