> The main table is rather huge, it has 90 columns and now after > three month it has 500.000 records... but in the end it has to store data of > 36 month. Hmm, I think you had better look at normalizing your data, and creating indexes. Start with the indexes since that won't force you to make any other changes, but 90 columns in one table sound like you put everything in that one table rather than normalizing. Take a look at this article for some (somewhat dated) info.
http://www.linux-mag.com/2001-06/mysql_01.html Also what version of MySQL are you running and what table type? Have you looked at the processes that are running when run your query? mysqladmin -p process Will show what is happening, another very useful tool is mytop: http://jeremy.zawodny.com/mysql/mytop/ Scott Helms -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]