Re: [phpOpenTracker-User] Simple Report timeout/server load

Thiess Rathjen wrote:
> I am not sure if this a mysql or pot problem.

  The simple_report sample application fires *a lot* of SQL queries.

  The most expensive phpOpenTracker API call is 'top'. This API call
  needs three SQL queries with MySQL versions prior to MySQL 4.1.0.
  If you're using MySQL 4.1.0 or later the 'top' API call will
  require only one SQL query and thus performs a lot faster.

> I am confident that with the mysql merge_tables feature it will be
> much better, but i found no way to split existing pot-tables.

  I started working on such a tool but abandoned it. If you need such a
  tool and think it'd be worth a DVD or two from my Amazon.de wishlist let
  me know ;-)

-- 
Sebastian Bergmann
http://sebastian-bergmann.de/                   http://phpOpenTracker.de/

Das Buch zu PHP 5: http://professionelle-softwareentwicklung-mit-php5.de/


-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf