[Tickets #6290] Minimize data loaded for listing galleries

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=6290
-----------------------------------------------------------------------
 Ticket             | 6290
 Created By         | Duck <duck at obala.net>
 Summary            | Minimize data loaded for listing galleries
 Queue              | Ansel
 Type               | Enhancement
 State              | New
 Priority           | 1. Low
 Milestone          | 
 Patch              | 
 Owners             | 
+New Attachment     | Ansel.diff
-----------------------------------------------------------------------


Duck <duck at obala.net> (2008-02-19 12:25) wrote:

In a common usage, no filtering galleries by attributes is sued (for
example browsing the default gallery list). So we do not need to read ID
values from DB. We can just count the number of galleries assessable by
current user. This can be done by not reading any data from DB just using
Datatree::countValuesByAttributes()  from bug #6289.

Numbers?
84k galleries, just counting and selecting the first page
current Ansel : 11,17 sec, memory used 13,37 MB.
patch applied: 7,67 sec, memory used 6,55 MB