- Home En
KB0102 - “Items in Order” report takes a long time to load
The standard report “Items in Order” takes more than 2 minutes to load.
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.
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
Applies to: RC 3.6 and 3.7
Reference: TFS #13316
Knowledge base ID: 0102
Last updated: Feb 23, 2016