Tickets :: Comment on [#6982] Optimized Tags

* Your Email Address
* Spam protection	Enter the letters below: .__.. ..___.\ /.___ [__]\|\/\| \| >< [__ \| \|\| \| \| / \\|
Comment	> 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
Attachment
Watch this ticket