Board index » delphi » How To Low Size of Interbase File
Augusto Campos
Delphi Developer |
Augusto Campos
Delphi Developer |
How To Low Size of Interbase File2004-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 |
aytharn
Delphi Developer |
2005-01-12 03:19:15 AM
Re:How To Low Size of Interbase File
Augusto Campos writes:
QuoteI have a DB Interbase 7.1 with the size 13Mb and i create a Blob Field in a 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! :-) |