[PHP-DB] Optimizing Tables

Hello group, I just have a quick question for you all. Here is it... Is it advisable to run optimize table after each deletion of a record? Thanks in advance, Anna Vester

Re: [PHP-DB] Optimizing Tables

On 4/1/07, Bastien Koert [EMAIL PROTECTED] wrote: I would say no, due to the overhead. What I would recommned is setting that up as a cron task and running it on a scheduled basis, usually when the server is liightly loaded. Monitor the server and pick an optimal time. This is the same for all