>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