RE: [PHP] Optimizing a Table with PHP

Another way is to say TRUNCATE tablename This actually deletes the table data and index files and recreates them. -Jason Garber IonZoft.com At 01:22 PM 10/12/2001 -0700, power jessie wrote:

OPTIMIZE TABLE tbl_name[,tbl_name]... http://www.mysql.com/doc/O/P/OPTIMIZE_TABLE.html hope that helps! jessie :) -----Original Message----- From: Chris Aitken [mailto:chris@ideal.net.au] Sent: Thursday, September 27, 2001 5:53 AM To: mysql@lists.mysql.com Cc: php-general@lists.php.net Subject: [PHP] Optimizing a Table with PHP Hi All, Im trying to do someting and im not finding much help out there on the web so im asking here if anyone has any pointers..... I have a MySQL database table full of like 12000 records on a FreeBSD box with apache/php4. and what I have is a script that when I run it, it deletes all records, and rebuilds this table with the updated 12000 records. But what happens, it keeps the size of the table huge, and only adds to it. Is there some way that after ive told PHP to delete all records, to optimize the table before writing all the new records ? Any help would be great. Cheers Chris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net