Support
Login
Your Password

Sales
North America
Phone: +1 (905)-655-9262
Fax: +1 (905)-655-9395
Email: info@add-on.com

Europe
Phone: +45 7944 7000
Fax: +45 7944 7001

China
Phone: +86 (21) 2221 8396
Email: info-china@add-on.com
Support
Denmark
+45 7944 7002

Europe
+44 (0) 203 002 3889

North America
+1 (202)-536-4165
Knowledgebase: Resource Central
KB0102 - “Items in Order” report takes a long time to load

 

Symptom

The standard report “Items in Order” takes more than 2 minutes to load.

 

Cause

SQL queries in the “Items in Order” report still use "dbo.udfConvertToLocal" function which is considered a "time-consuming" one, and this function is repeatedly called when the report is loaded.

 

Resolution

You can update the software to RC 3.7.10, in which the performance of this report has been improved.

Comparison statistics (selected duration for the report is in the range of 1 month):

RC 3.6 and RC 3.7:      about 140 seconds

RC 3.7.10:                     3-4 seconds

 

Properties

Applies to: RC 3.6 and 3.7

Reference: TFS #13316

Knowledge base ID: 0102

Last updated: Feb 23, 2016