Performance Issues Sage 50US V2020

From Sage Intelligence Knowledgebase
Jump to: navigation, search

Products

Sage 50US V2020


Description

Performance issues when running customized reports on Sage 50US V2020

Cause

Customized reports may experience performance degradation as a result of the latest update to the Sage 50US V2020 database driver.


Resolution

Should you experience a performance impact when running Sage Intelligence reports for Sage 50US V2020, please debug the custom SQL to isolate were the area of impact may exist. We've noticed that in some cases, the latest driver processes joins much quicker than previous instances and this could assist performance when running out reports.

NB: Standard report/s should not experience any of the above issues.