[Tickets #6982] Re: Optimized Tags

bugs at horde.org bugs at horde.org
Sun Dec 14 15:56:12 UTC 2008


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.





More information about the bugs mailing list