Enhancing report speed using SQL

Generating lengthy reports that evaluate a large number of records can create a processing burden for the data server that may affect the EBMS performance of other uses.     Long reports may require a substantial amount of time to generate.   Both of these issues can be resolved by generating reports from the mirrored SQL database rather than directly from the EBMS files.   

This speed enhancement option will be most useful for long reports or summaries that use detailed data such as sales detail or general ledger transactions.  The SQL options requires the SQL mirror to implement this reporting speed enhancement.   Review the SQL Mirror > Overview section for details on this performance tool.

The option to identify the Data Source is located on the top of the report prompt as shown below:

Review Technical > Performance Enhancements for more speed enhancement options.