Defect #1477

Orders view load time

Added by Blatti Yves 4 months ago. Updated 4 months ago.

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


Target version:4.5.2
Affected version:4.0.0


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


#1 Updated by Blatti Yves 4 months ago

  • Description updated (diff)

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

Also available in: Atom PDF