Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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
titleSQL skills are required

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
nameusp_Jiwa_Debtors_SalesHistorys_7.2.3.sql
height250

Filter by label (Content by label)
showLabelsfalse
max5
spacesJ7UG
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel in ("sales_tab","debtors_maintenance","debtors","sales") and type = "page" and space = "J7UG"
labelsdebtors debtors_maintenance sales sales_tab

...