Re: [phpOpenTracker-User] Speeding up OpenTracker Reporting

Christopher Hogan wrote:
> I use MySQL version 3.23.52 with delay_key_write enabled.  This is a
> dedicated database server;

  DELAY_KEY_WRITE only improves the INSERT performance.

  To improve your SELECT performance I recommentd the MySQL Merge
  Tables handler. Also note that MySQL 4.1 increases the phpOpenTracker
  API performance dramatically because of its support for subqueries
  and the query cache.

> I've noted that by dropping the table indexes speed increases are
> possible:

  Dropping indexes increases INSERT performance while decreasing the
  SELECT performance.

> I've looked into MERGE tables however I'm a bit unsure of how to set
> something like this up for opentracker; is it possible that someone
> could provide me with an example?  Would this increase the speed of
> reporting or just logging?

  It's not that hard to do and (hopefully well) documented in the
  manual.

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