User Tools

Site Tools



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

Link to this comparison view

dynamiczip:reports:sql_optimized_reports [2015/03/11 20:10] (current)
Line 1: Line 1:
 +====== SQL Optimized Reports ======
 +The original [[dynamiczip:​reports:​DynamicZip Tax Reports]] were generated using native Dexterity code and local c-tree temporary tables. For a company with a lot of transactions,​ these reports could take an unacceptable length of time to generate. That is why we created SQL Optimized versions of the reports. ​
 +Although maintaining two versions is extra work, it has proven to be a great way for us to catch errors in the reports. The Non-Optimized reports also provide our customers with an alternative way to generate a needed report, should the SQL Optimized version fail for any reason. ​
 +[[dynamiczip:​reports:​reports|DynamicZip Reports]]
dynamiczip/reports/sql_optimized_reports.txt ยท Last modified: 2015/03/11 20:10 (external edit)