Tickets :: Comment on [#6982] Optimized Tags

* Your Email Address
* Spam protection	Enter the letters below: __ . . .. .. . / `\| \ /\|__\|\|\/\| \__.\|___ \/ \| \|\| \|
Comment	> I think that this can probably be resolved for now, though I'll leave > it up to Michael. A lot of different options are now available from > the Rampage Tagger code in the incubator, including stat tables that > take care of caching counts for tags and tags + users (and this adds > user_id to the current Ansel structure, allowing folksonomy-type > stuff which Ansel doesn't currently have). > > > > On HAVING vs. the JOIN - HAVING might be quicker in some cases but > using a JOIN also lets us exclude tags from the result set, and it > also avoids some filesorting most of the time. So the rampage tagger > goes with the JOIN solution.
Attachment
Watch this ticket