should I optimize the database after removing records

[eluser]Flying Fish[/eluser]
I'm just adding a method to one of my models to remove some records from my db, should I tell it to optimize the db at the end of the function?

Just curious if this would be a good idea.

[eluser]TheFuzzy0ne[/eluser]
Probably not. Database optimisation shouldn't take place that regularly as it can put strain on your server. I would recommend once an hour at most, or perhaps even once a day. It all depends on server traffic and how often you delete data.

[eluser]Flying Fish[/eluser]
Thanks. I think the way it looks in the phpmyadmin interface, just makes me want to optimize it all the time :-) Maybe I'm a bit obsessive.

[eluser]Dam1an[/eluser]
Once you know the quiet periods on your site, I would recommend setting up a cron job to run at that time