[Tickets #6295] Ansel flat shares with hierarchies

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/?id=6295
-----------------------------------------------------------------------
 Ticket             | 6295
 Created By         | Duck <duck at obala.net>
 Summary            | Ansel flat shares with hierarchies
 Queue              | Ansel
 Type               | Enhancement
 State              | New
 Priority           | 1. Low
 Milestone          | 
 Patch              | 
 Owners             | 
+New Attachment     | ansel-flat.tgz
-----------------------------------------------------------------------


Duck <duck at obala.net> (2008-02-20 04:10) wrote:

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.