Have one more question - indexing the relevant columns based on the explain info has made all of our queries immensely faster.
But it appears that new rows are not automatically indexed. Does anyone know about this and if they are not indexed how do I reindex the tables?
They should be indexed on insert under normal circumstances.
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]