Defect #1477

Orders view load time

Added by Blatti Yves about 1 month ago. Updated about 1 month ago.

Status:ResolvedStart date:06/18/2019
Priority:NormalDue date:
Assignee:Blatti Yves% Done:

100%

Category:SHOP
Target version:4.5.2
Affected version:4.0.0

Description

Orders view (in backend) load time increases rapidly with data volume (order, accounts, organisms, etc.)

History

#1 Updated by Blatti Yves about 1 month ago

  • Description updated (diff)

#2 Updated by Blatti Yves about 1 month ago

  • Status changed from Affected to Resolved
  • % Done changed from 0 to 100

SQL Query time cut by 50% by using DISTINCT instead of GROUP BY in orders model

Also available in: Atom PDF