Benji Spencer wrote:
Indexes we can add, which we have. Unfortunately we are dealing with a packaged application which we have only some abilities to deal with the code (a total switch to MySQL we could rewrite the code for, but we can not optimize specific queries as there is a common SQL generator which actually generates the SQL statement).
That can be a pain, of course, but if you have control over the MySQL side, make sure you turn on query logging to see what queries are generated so as to optimize the indexes, etc. for them.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
