Opened 5 years ago

Closed 5 years ago

Last modified 4 years ago

#957 closed defect (fixed)

tag cloud makes separate mysql query for every single tag

Reported by: _ck_ 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)

comment:1   _ck_5 years ago

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

comment:2   _ck_5 years ago

  • Priority changed from normal to high
  • Severity changed from normal to major
  • Resolution set to fixed
  • Status changed from new to closed

(In [1700]) Allow bb_get_tag_link() accept an object in the first parameter. Deprecate last instances of bb_get_tag_by_name(). Fixes #957

  • Milestone 1.0-beta deleted

Milestone 1.0-beta deleted

  • Milestone set to 1.0
Note: See TracTickets for help on using tickets.