[Tickets #6982] Re: Optimized Tags

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/6982
------------------------------------------------------------------------------
  Ticket             | 6982
  Updated By         | Chuck Hagenbuch <chuck at horde.org>
  Summary            | Optimized Tags
  Queue              | Ansel
  Type               | Enhancement
-State              | Feedback
+State              | Assigned
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             | Michael Rubinsky
------------------------------------------------------------------------------


Chuck Hagenbuch <chuck at horde.org> (2008-12-14 10:56) wrote:

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.