Nissim Lugasy writes:
> Why is it that when I delete records from a table in the database, the size
> of the table's MYD file does not get smaller. It's still the original size.
> Do I have to flush the table to get the accurate size?
OPTIMIZE TABLE is what you want. But doing it after each a
On Tue, 04 Dec 2001 12:53:33 -0500, Nissim Lugasy <[EMAIL PROTECTED]>
wrote:
>>Why is it that when I delete records from a table in the database, the size
>>of the table's MYD file does not get smaller. It's still the original size.
>>Do I have to flush the table to get the accurate size?
run
Shrinking the database immediately would be too slow for most purposes.
When you delete a record the database flags it as ready to be recycled.
Inserts will always try to recycle a deleted slot where possible. If you
delete a really big block of records and want to reclaim the disk space you
can