>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:aserev@xxxxxxxxx] Sent: Sunday, April 01, 2007 3:36 PM To: php-db@xxxxxxxxxxxxx Subject: Optimizing Tables 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
