Tickets :: 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