>From the MySQL manual:

OPTIMIZE TABLE should be used if you have deleted a large part of a
table or if you have made many changes to a table with variable-length
rows (tables that have VARCHAR, VARBINARY, BLOB, or TEXT columns).
Deleted rows are maintained in a linked list and subsequent INSERT
operations reuse old row positions. You can use OPTIMIZE TABLE to
reclaim the unused space and to defragment the data file.

So, no, do not optimize table after each row deletion.

-----Original Message-----
From: Anna V [mailto:[EMAIL PROTECTED] 
Sent: Sunday, April 01, 2007 3:36 PM
To: php-db@lists.php.net
Subject: Optimizing Tables

Hello group,

I just have a quick question for you all. Here is it... Is it advisable
run optimize table after each deletion of a record?

Thanks in advance,

Anna Vester

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

Reply via email to