#11 general speed upgrade

open
nobody
None
3
2006-08-23
2006-07-26
No

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.

Discussion

    • priority: 5 --> 3
     
  • 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.