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
monitoring
etc.
hth
Bastien
From: Anna V [EMAIL PROTECTED]
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
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