Hi All, Is there a way to automatically optimize a table anytime data is changed. I have a table that only has changes made to it occasionally (average over a 1 week period is probably 1 row is updated each day), and I would like it to automatically optimize the table, rather than having to do it manually. I know that I could setup a cron job to do this, or modify my client scripts to automatically optimize the table after doing an insert/update/delete, but I am wondering if there is a better way to do this. Is there perhaps a change I can make in the table structure that will cause it to auto-optimize whenever data changes are made?
Thanks for any suggestions! -Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
