Re: [PHP-DB] Optimizing Tables

[Anna V]

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 server mainenance type situations like index
monitoring
etc.



That sounds reasonable. Thanks alot for your quick response.

RE: [PHP-DB] Optimizing Tables

[Bastien Koert]

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" <[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?

Thanks in advance,

Anna Vester


_
http://local.live.com/?mkt=en-ca/?v=2&cid=A6D6BDB4586E357F!420

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php