6.0.0-beta1
7/6/25

[#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 (6347 days ago)
Due
Updated 02/20/2008 (6346 days ago)
Assigned
Resolved 02/20/2008 (6346 days ago)
Milestone
Patch No

History
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 Download
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


Saved Queries