Problem
When there is a significant sales history for a debtor, loading debtor maintenance and clicking on the Sales tab will take several minutes.
Solution
Warning | ||
---|---|---|
| ||
A working knowledge of SQL Management Studio is required to complete this task |
The stored procedure has been optimised and now returns data quickly e.g. data took 2 mins, 10 seconds before optimisations and after optimising 18 seconds. This fix applies
The following stored procedure may be applied to 7.02.00 and 7.02.1 databases
...
.
...
View file | ||||
---|---|---|---|---|
|
Related articles
Filter by label (Content by label) | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...