Actions
Bug #6987
closed
Hidden rows that don't exist cause performance drop
Description
When there's hidden rows for activity that doesn't exist it results in performance drop when outputting the hidden activity page.
Updated by krileon almost 7 years ago
Best way to fix this seams to be to change the hidden query to a union usage to combine the 3 hidden type checks. Maybe a new API library should be implemented specifically for handling hidden activity, comments, etc..
Updated by krileon almost 7 years ago
Nope, no union needed. Simplify the join to only join the viewing users hidden rows as a LEFT join. Next add the filtering to the WHERE statement directly. Drops the query to 0.02s average.
Updated by krileon almost 7 years ago
- Status changed from Assigned to Resolved
- % Done changed from 0 to 100
Updated by krileon almost 7 years ago
- Status changed from Resolved to Assigned
- % Done changed from 100 to 50
Updated by krileon almost 7 years ago
Only fix for this was to indeed use a union of 3 queries to the 3 different hidden types.
Updated by krileon almost 7 years ago
- Status changed from Assigned to Resolved
- % Done changed from 50 to 100
Actions