On 10/5/07, Christopher Schultz <[EMAIL PROTECTED]> wrote: > 1. Your queries/indexes suck and you need to adjust them appropriately.
+1 on that possibility :-) I had a MySQL-based app that had slowed dramatically as the table (product inventory) size grew. Just changing some old-style queries, e.g. SELECT a, b, c FROM x, y, z WHERE... to SELECT a, b, c FROM x LEFT JOIN y ON ...LEFT JOIN z ON ... cut the query time from tens of seconds to sub-second. If it's a possible problem with indexes, MySQL's EXPLAIN is helpful. FWIW, -- Hassan Schroeder ------------------------ [EMAIL PROTECTED] --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
