User Tools

Site Tools


dynamiczip:faq:running_sql_optimized_reports_faq

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

dynamiczip:faq:running_sql_optimized_reports_faq [2015/03/05 23:26] – external edit 127.0.0.1dynamiczip:faq:running_sql_optimized_reports_faq [2017/05/10 17:15] (current) conni
Line 1: Line 1:
 ======What's the difference between running SQL Optimized and non-SQL Optimized reports?====== ======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. + 
 +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:faq:identifying_documents_that_cause_reporting_errors|SQL error]]. 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:faq:identifying_documents_that_cause_reporting_errors|SQL error]].
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