Re: Optimizing a Table with PHP
| From: | Jason Brooke | Date: | Thu, 27 Sep 2001 13:38:32 +0000 |
| Subject: | Re: Optimizing a Table with PHP | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-69003@lists.php.net to get a copy of this message | ||
> 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.
>
> Chris
Yep, send an 'optimize table tablename' command via mysql_query()
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm
inistration.html#OPTIMIZE_TABLE
jason