Optimizing a Table with PHP
| From: | Chris Aitken | Date: | Thu, 27 Sep 2001 12:52:52 +0000 |
| Subject: | Optimizing a Table with PHP | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-68997@lists.php.net to get a copy of this message | ||
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