I know that SQL Server and Oracle work this way. I don't know about MySQL but I wouldn't be surprised if it does it.
>Interesting Hector
>
>thats new to me, I must make a mental note of that
>
>
>
>>>All,
>>>
>>>I am using VFP+Mysql to develop a program. One mysql table records have 700,000 and file size have 150M. But after I deleted all records and updated that table size still is 150M. When I insert a record to this table the update speed become very very slow.
>>>
>>>Anyone have these experiences can share with us?
>>I have no idea how MySQL works, but in some DBMS you "reserve" beforehand how much space will the database take. This allows the DBMS to do a more efficient handling of the space since it is already blocked for it own use. If MySQL works under this concept, it is possible that you (or MySQL) reserved this 150MB already and therefore it will not go down if you delete all records in table.
Hector Correa