Justtechjobs.com Find a programming school near you






Online Campus Both


php-general | 2001092

[PHP] Optimizing a Table with PHP From: Chris Aitken (chris <email protected>)
Date: 09/27/01

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 <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>