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 15:26] sylvainair [Readability] |
en:v8_0_0:howto:bestpractices [2020/07/07 16:14] (current) sylvainair [Limit processing time] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | #TODO | ||
| - | |||
| - | #WORKINPROGRESS | ||
| - | |||
| ====== Best Pratices ====== | ====== Best Pratices ====== | ||
| <WRAP round tip> | <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. | 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. | ||
| Line 20: | Line 15: | ||
| To minimize response times: | To minimize response times: | ||
| - | * Use the key fields for joins. | + | * Use the key fields for [[en:v8_0_0:designer:menus:accueil:nouvellerequete:jointures|joins]]. |
| - | * Use standard joins. | + | * Use [[en:v8_0_0:designer:menus:accueil:nouvellerequete:jointures#standard joins|standard joins]]. #TBC |
| - | * Use the key fields for the selection criteria. | + | * 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 parameters **only if required**. | + | * Allow wildcards ("*") of the interactive selection [[en:v8_0_0:designer:menus:accueil:nouvellerequete:parametres|parameters]] **only if required**. |
| - | * Set a maximum duration of execution if there is a risk of significant duration. | + | * [[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> | <WRAP round tip> | ||
| Line 40: | 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}} |
| - | {{: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"). |
| - | * Use the related queries: from the most synthetic to the most detailed vision ("drill down"). | + | |