Board index » delphi » How To Low Size of Interbase File

How To Low Size of Interbase File


2004-10-15 02:20:32 AM
delphi224
I have a DB Interbase 7.1 with the size 13Mb and i create a Blob Field in a
table and copy some images to the db and it get 1,5GB then I delete de Field
and the size is the same!!!
How Can i put a database with the used Size Only (Sweep Does'n work!!!)
Thanks
 
 

Re:How To Low Size of Interbase File

Augusto Campos writes:
Quote
I have a DB Interbase 7.1 with the size 13Mb and i create a Blob Field in a
table and copy some images to the db and it get 1,5GB then I delete de Field
and the size is the same!!!

How Can i put a database with the used Size Only (Sweep Does'n work!!!)

Thanks


because a database server is made for inserting data, and when you
delete something it will simply add a new record sayn' "this record has
been deleted" so if you want to really "clean" the table you have make a
backup of your data, drop them and finally restore, this because the
backup procedure take care to save only records not affected by deleting
records
SO;
make a backup of the database
restore it
finish and go home happy! :-)