search

bgarrels / textpattern

Automatically exported from code.google.com/p/textpattern
0 stars 0 forks source link

Optimizing admin-side queries #306

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
Some of the admin-side SQL statements either eat too much resources or do not 
scale well enough when the site grows.

One example of this is the Article list panel (?event=list) which strangely 
fetches section, author and category names when looping over the results making;

A. maximum of 400 queries.
B. eating memory and runtime which increases rapidly when site grows
C. most importantly makes correct sorting impossible.

C. also one of the reasons why these details where never present in the table 
but just used for tooltips; table can not be sorted by these values.

For example the list panels maximum of 400 queries can be dropped to 1 with 
couple LEFT JOINS.

Original issue reported on code.google.com by jukka.m.svahn on 2 Nov 2012 at 3:53