Joshua Beall wrote:
I hardly think it's worthwhile to optimize the table after 1 row being updated.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
You need to optimize the table after a *lot* of rows are updated - mainly deleted.
The only way I can think of doing this automatically is by adding something to the client end - unless you want to run a cron job.
Is there any particular reason why you think the table will need optimizing, or do you just want everything to be super-optimized?
Dan
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
