#957 closed defect (fixed)
tag cloud makes separate mysql query for every single tag
| Reported by: |
|
Owned by: | |
|---|---|---|---|
| Priority: | high | Milestone: | 1.0 |
| Component: | Back-end | Version: | |
| Severity: | major | Keywords: | |
| Cc: |
Description
If you have 100 tags in your front-page tag cloud, build 1681 makes 100 mysql queries. I doubt that was intended.
Change History (5)
- Priority changed from normal to high
- Severity changed from normal to major
- Resolution set to fixed
- Status changed from new to closed
Note: See
TracTickets for help on using
tickets.
The extra queries may be caused by this first query failing, perhaps 'bb_topic_tag' was meant to be $bb_topic_tag or some other string of comma delimited numbers?
SELECT t.*, tt.* FROM bb_terms AS t INNER JOIN bb_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('bb_topic_tag') AND tt.count > 0 ORDER BY tt.count DESC LIMIT 40