6.0.0-beta1
▾
Tasks
New Task
Search
Photos
Wiki
▾
Tickets
New Ticket
Search
dev.horde.org
Toggle Alerts Log
Help
2/27/26
H
istory
A
ttachments
C
omment
W
atch
Download
Comment on [#6295] Ansel flat shares with hierarchies
*
Your Email Address
*
Spam protection
Enter the letters below:
.__ . ..__ . ._. [__)| |[ __| | | \|__|[_./|____|_
Comment
> Finally I had some time to merge my flat share driver from request # > with some hierarchies logic from DataTree. The result is a new share > driver for Ansel galleries speeding listing of my 86k galleries to an > usable stage. > > > > 84k galleries, just counting and selecting galleries on the first > page (9 galleries as default pref) > > current Ansel : 11,17 sec, memory used 13,37 MB. > > applied bug #6290: 7,67 sec, memory used 6,55 MB > > **using this driver: 0,12 sec, memory used 4,98 MB** > > > > The main performance benefit is of removing nested joins from > datatree attributes table to a flat table. Where we have every > attribute in a dedicated indexed column. So every gallery has only > one row. I called it share driver. I am going to investigate more. As > we still select galleries with two queries.
Attachment
Watch this ticket
N
ew Ticket
M
y Tickets
S
earch
Q
uery Builder
R
eports
Saved Queries
Open Bugs
Bugs waiting for Feedback
Open Bugs in Releases
Open Enhancements
Enhancements waiting for Feedback
Bugs with Patches
Enhancements with Patches
Release Showstoppers
Stalled Tickets
New Tickets
Horde 5 Showstoppers