Tickets :: [#6290] Minimize data loaded for listing galleries

Summary	Minimize data loaded for listing galleries
Queue	Ansel
Type	Enhancement
State	Resolved
Priority	1. Low
Owners	mrubinsk (at) horde (dot) org
Requester	duck (at) obala (dot) net
Created	02/19/2008 (6370 days ago)
Due
Updated	02/20/2008 (6369 days ago)
Assigned
Resolved	02/20/2008 (6369 days ago)
Milestone
Patch	No

02/20/2008 08:27:54 PM	Michael Rubinsky	Comment #3 State ⇒ Resolved	Reply to this comment
Committed with just some small phpdoc tweaks. Thanks!

02/19/2008 09:21:48 PM	Chuck Hagenbuch	Comment #2 Assigned to Michael Rubinsky State ⇒ Accepted	Reply to this comment
Accepted pending ~~request 6289~~.

02/19/2008 05:25:59 PM	Duck	Comment #1 Priority ⇒ 1. Low Type ⇒ Enhancement Summary ⇒ Minimize data loaded for listing galleries Queue ⇒ Ansel New Attachment: Ansel.diff State ⇒ New	Reply to this comment
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