Actions
Feature proposal #6482
closed
Improve scalability
Description
Currently the query usages can't scale beyond a certain point as it increasingly decreases performance as more rows are added. This is due mostly in part to over use of subqueries and joins. Comments and Tags counting should be a prefetch function after rows are built to avoid such a costly subquery. Removal of hidden rows can be an optimized join. GJ should reduce to 1 query addition (instead of 1 for each integration) and use a EXISTS with a subquery.
Updated by krileon almost 8 years ago
Scalability test with query improvements done with 12,000 activity rows and 12,000 comment rows. Adding more rows no longer appears to significantly negatively impact performance.
Actions