User Tools

Site Tools


dynamiczip:faq:running_sql_optimized_reports_faq

What's the difference between running SQL Optimized and non-SQL Optimized reports?

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 SQL error.


Frequently Asked Questions

dynamiczip/faq/running_sql_optimized_reports_faq.txt · Last modified: 2017/05/10 17:15 by conni

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki