Enhancement #1442

SQL slowdowns on Shop > Requests

Added by Bubloz Ivan about 1 year ago. Updated 5 months ago.

Status:ClosedStart date:10/03/2017
Priority:NormalDue date:
Assignee:Van Hoecke Hélène % Done:

100%

Category:SHOP
Target version:4.5.0
Sponsor: Ergonomic impact:

Changes the way filters work

Functional impact:

Improve pages loading


Description

On the page "Requests" (Frontend) the data loading is very slow.

The Organisms query (for filters) in the pending view would be ignored because it not used at this status.

In the Requests view, we implemented a new optional parameter "filter_smartview".
It optimize SQL queries and forces the user to choose a filter.
This prevente using "JPagination" with several thousand rows.

Snap.png (115 KB) Bubloz Ivan, 10/03/2017 10:19 AM

History

#1 Updated by Bubloz Ivan about 1 year ago

  • File deleted (Snap.png)

#2 Updated by Blatti Yves 12 months ago

  • Status changed from Request For Comments to Accepted

#3 Updated by Blatti Yves 12 months ago

  • Status changed from Accepted to Affected
  • Assignee changed from Technical Committee to Bubloz Ivan

Voted on 2017-10-26

#4 Updated by Bubloz Ivan 12 months ago

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

#5 Updated by Bubloz Ivan 12 months ago

  • Status changed from Resolved to To merge

#6 Updated by Blatti Yves 8 months ago

  • Assignee changed from Bubloz Ivan to Van Hoecke Hélène

#7 Updated by Van Hoecke Hélène 5 months ago

  • Status changed from To merge to Closed

Also available in: Atom PDF