Subject | Re: [firebird-support] database growing too much after bulk |
---|---|
Author | Sergio H. Gonzalez |
Post date | 2008-11-06T13:03:39Z |
> To reiterate: deleting records or dropping tables does NOT reduce the size ofThanks Helen and Ann !! You are very kind!
> the database file.
> ./heLen
The size of the bigger database was taken *after* doing a backup/restore.
Doesn't that discard all the deleted records?
Can this behaviour be a kind of database corruption or is just normal?
This is the last test I did:
1) I made an script of the database and re-created it (with IBExpert, personal
edition). At this point the STOCK table was empty. DB Size = about 4 MB
2) I ran my import app, to import the stock table from a DBF file. Just in case
I do just one commit at the end of the import (about 40.000 records). DB Size =
179 MB
3) Again I made an script of the database (metadata & data, of course!) and
re-created it. DB Size 13MB
I wander if the problem may be with blob fields...
Thanks a millon for any help !!
-s