meta data for this page
  •  

This is an old revision of the document!

#TODO

#WORKINPROGRESS

Best Pratices

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.

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 joins.
  • Use standard joins.
  • Use the key fields for the selection criteria.
  • Allow wildcards (“*”) of the interactive selection parameters only if required.
  • Set a maximum duration of execution if there is a risk of significant duration.

If the extraction absolutely requires a duration incompatible with interactivity, use the scheduled execution.

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 data selections using parameters.
  • Use the grouping functions.
  • Use the related queries: from the most synthetic to the most detailed vision (“drill down”).