SQL slowdowns on Shop > Requests
|Assignee:||Van Hoecke Hélène||% Done:|
Changes the way filters work
Improve pages loading
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.