Subject | Re: [IBO] Store an Restore a file from a BLOB field |
---|---|
Author | Svein Erling Tysvær |
Post date | 2005-01-19T15:39:31Z |
You probably know this already, but once Firebird has allocated space
in a file, it doesn't normally give that space back to the file
system. Hence, if you have one database and delete some records, then
Firebird keeps that empty space for reuse. When inserting new records,
the file size will not increase at all until it really needs more
space (also, I don't think the file size increases with the size of
one record at a time).
Just a note in case you believed you could simply look at the file
size of the database,
Set
in a file, it doesn't normally give that space back to the file
system. Hence, if you have one database and delete some records, then
Firebird keeps that empty space for reuse. When inserting new records,
the file size will not increase at all until it really needs more
space (also, I don't think the file size increases with the size of
one record at a time).
Just a note in case you believed you could simply look at the file
size of the database,
Set
> Sorry Dmitry,
>
> but even this way NO ONE (zero) bytes was writen in the file, when
> REALLY some is stored in the field...
>
> It looks like the BLOB still not in memory, and was none to write in
> the stream.
>
> I know blob fields are not retrieved until necesary (not recovered
> at fetch the rest of row), how I can FORCE to load into memory? Im
> sure THEN I can do AssignTo sucesfully.