Defect #1477

Orders view load time

Added by Blatti Yves 6 months ago. Updated 3 days ago.

Status:ClosedStart 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 6 months ago

  • Description updated (diff)

#2 Updated by Blatti Yves 6 months 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

#3 Updated by Blatti Yves 3 days ago

  • Status changed from Resolved to To merge

#4 Updated by Blatti Yves 3 days ago

  • Status changed from To merge to Closed

Also available in: Atom PDF