PHP DB - RE: [PHP-DB] Optimizing Tables

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

RE: [PHP-DB] Optimizing Tables

Bastien Koert

2007-04-01, 6:57 pm

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...6D6BDB4586E357F!420

Sponsored Links