Incubator » CB Activity

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.