| Summary | Optimized Tags |
| Queue | Ansel |
| Type | Enhancement |
| State | Feedback |
| Priority | 1. Low |
| Owners | Michael Rubinsky <mrubinsk (at) horde (dot) org> |
| Requester | Duck <duck (at) obala (dot) net> |
| Created | 06/26/2008 (73 days ago) |
| Due | |
| Updated | 07/15/2008 (54 days ago) |
| Assigned | 06/30/2008 (69 days ago) |
| Resolved | |
| Attachments | ansel-tags.diff ![]() |
| Milestone | |
| Patch | No |
Milestone ⇒
enhancement though, once the gallery vs image tag count issue is
resolved.
tag count. Is used only as a flag if the gallery/image has tags or
not to save later queries. So this can be a boolean value.
and then your using the value of that field directly in
Ansel_Tags::readTags() and Ansel_Tags::listTagInfo(). With your
changes, once any tags are added/removed from an image or gallery, the
tag counts will never be correct because the value in the
ansel_tags.tag_count field is only taking into account the number of
times that tag is used in _either_ the images table *or* the galleries
table, when it needs to be both.
overwritten with the count of tags in *either* the ansel_images_tags
or ansel_galleries_tags table...when it should be both.
tag count. Is used only as a flag if the gallery/image has tags or not
to save later queries. So this can be a boolean value.
overwritten with the count of tags in *either* the ansel_images_tags
or ansel_galleries_tags table...when it should be both.
is a bit, well, boring and wasteful considering that the "Browse"
page can be configured with a cloud of whatever size the user wants.
Assigned to Michael Rubinsky
is a bit, well, boring and wasteful considering that the "Browse" page
can be configured with a cloud of whatever size the user wants. I
suppose I can be convinced differently if there is a compelling reason
that I am missing or the Cloud page contained some other widgets/info
etc...
iteration/concatenation in gallery.php instead of using implode()?
Is there a big performance difference?
even the tag count
iteration/concatenation in gallery.php instead of using implode()?
Is there a big performance difference?
New Attachment: cloud.php
New Attachment: ansel-tags.diff
Patch ⇒
Milestone ⇒
Queue ⇒ Ansel
Summary ⇒ Optimized Tags
Type ⇒ Enhancement
Priority ⇒ 1. Low
State ⇒ New
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