[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         | Duck <duck at obala.net>
  Summary            | Optimized Tags
  Queue              | Ansel
  Type               | Enhancement
  State              | Assigned
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             | Michael Rubinsky
+New Attachment     | Tags.diff
------------------------------------------------------------------------------


Duck <duck at obala.net> (2008-10-31 12:21) wrote:

> Removing as a showstopper, tags work, this would be a nice
> performance enhancement though, once the gallery vs image tag count
> issue is resolved.

And here it is solved. When we fill the ansel_tags table we count both  
images and galleries table. To be more simple, I reduced the amount of  
changes just to introduce the tag_count column and avoid the double  
UNION SELECT. Other performance patches will come after this will be  
commited.