RE: [PHP-DB] Optimizing Tables
| From: | Bastien Koert | Date: | Sun, 01 Apr 2007 19:44:25 +0000 |
| Subject: | RE: [PHP-DB] Optimizing Tables | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-43391@lists.php.net to get a copy of this message | ||
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 server mainenance type situations like index monitoring etc.
hth
Bastien
From: "Anna V" <aserev@gmail.com> To: php-db@lists.php.net Subject: [PHP-DB] Optimizing Tables Date: Sun, 1 Apr 2007 14:35:51 -0500 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_________________________________________________________________ http://local.live.com/?mkt=en-ca/?v=2&cid=A6D6BDB4586E357F!420