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]
127.0.0.1 external edit
dynamiczip: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