dynamiczip:faq:running_sql_optimized_reports_faq
Differences
This shows you the differences between two versions of the page.
dynamiczip:faq:running_sql_optimized_reports_faq [2015/03/05 23:26] – external edit 127.0.0.1 | dynamiczip:faq:running_sql_optimized_reports_faq [2017/05/10 17:15] (current) – conni | ||
---|---|---|---|
Line 1: | Line 1: | ||
======What' | ======What' | ||
- | Temporary tables are required to create our tax reports. The difference between SQL Optimized and non-SQL Optimized reports is the SQL Optimized process builds the temp tables on the Microsoft SQL Server>> | + | |
+ | Temporary tables are required to create our tax reports. The difference between SQL Optimized and non-SQL Optimized reports is the SQL Optimized process builds the temp tables on the Microsoft SQL Server using SQL queries, while the non-SQL Optimized process builds the temp tables on the local workstation using native Dexterity. | ||
Printing SQL Optimized is generally faster than printing non-SQL Optimized. We only recommend printing non-SQL Optimized in the event that an atypical document causes your DZ report to fail with a [[dynamiczip: | Printing SQL Optimized is generally faster than printing non-SQL Optimized. We only recommend printing non-SQL Optimized in the event that an atypical document causes your DZ report to fail with a [[dynamiczip: |
dynamiczip/faq/running_sql_optimized_reports_faq.txt · Last modified: 2017/05/10 17:15 by conni