[Tickets #6982] 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
  Created By         | Duck <duck at obala.net>
  Summary            | Optimized Tags
  Queue              | Ansel
  Type               | Enhancement
  State              | New
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
+New Attachment     | ansel-tags.diff
------------------------------------------------------------------------------


Duck <duck at obala.net> (2008-06-26 10:49) wrote:

The UNION ALL SELECT query is very waste full SQL command. Expecially  
with the kind of table that tags are implemented with. Is taking  
seconds for my installations with a lot of images. As the server must  
read all table data to perform the counting and proper selection of  
data. So we must help the server and perform the count on the rare  
update operations to have fast common selections.

The patch:
reorganize the Ansel_Tags object store the store counts of used tags  
in the tags table to not count on the fly
mark galleries and images if they have tags or not so we can avoid not  
needed queries with all galleries and images that does not have tags.
Add limit functionality to the tags cloud block