+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: should I optimize the database after removing records (/showthread.php?tid=17934)
should I optimize the database after removing records - El Forum - 04-20-2009
[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.
should I optimize the database after removing records - El Forum - 04-22-2009
[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.
should I optimize the database after removing records - El Forum - 04-22-2009
[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.
should I optimize the database after removing records - El Forum - 04-22-2009
[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