general speed upgrade
Status: Inactive
Brought to you by:
borvik
I have patched my dbwebmail with the search patch I
mentioned before, but still I notice a big load in
php, and a minor load in MySQL.
It seems that much more is done in PHP than in MySQL.
We probably want to bring more logic to MySQL, and
optimize the PHP code little more.
Logged In: YES
user_id=1453793
Well, progress is being made toward this end.
In an effort to get PostgreSQL supported (some SQL
statements must be different), the SQL statements are being
put in their own file (for their respective DB types).
The box list (and box count) were previously handled by PHP
generated sql statements. Now they are handled in just a
few lines and no generated SQL everything is handled in the
SQL statement via OR statements to select the correct set of
conditions for the current box.
Search still doesn't work on the AJAX tree, so when that
get's going it should work the same way.