[#6290] Minimize data loaded for listing galleries
Summary Minimize data loaded for listing galleries
Queue Ansel
Type Enhancement
State Resolved
Priority 1. Low
Owners Michael Rubinsky <mrubinsk (at) horde (dot) org>
Requester Duck <duck (at) obala (dot) net>
Created 02/19/2008 (231 days ago)
Due
Updated 02/20/2008 (230 days ago)
Assigned
Resolved 02/20/2008 (230 days ago)
Attachments Ansel.diff Download
Milestone
Patch No

History
02/20/2008 Michael Rubinsky Comment #3
State ⇒ Resolved		 Reply to this comment
Committed with just some small phpdoc tweaks.

Thanks!
02/19/2008 Chuck Hagenbuch Comment #2
State ⇒ Accepted
Assigned to Michael Rubinsky		 Reply to this comment
Accepted pending request 6289.
02/19/2008 Duck Comment #1
New Attachment: Ansel.diff Download
Queue ⇒ Ansel
Summary ⇒ Minimize data loaded for listing galleries
Type ⇒ Enhancement
Priority ⇒ 1. Low
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