---------- Original Message -----------
From: "AshimQuikStor" <ashimquikstor@...>

> yes I'm using BLOB but not that much. 1/500 transaction are BLOBs
>
> firebird will release the memory just when i disconnect !!!!

------- End of Original Message -------

Are you using the LIST() aggregate function, which creates temporary blobs? Are
you generally dealing with either NULL, small, or large blobs? "1 in 500" is not
very many, but what's the volume like? Are you performing one million inserts in
one database transaction, and among those, only 1 in 500 involves inserting or
updating a non-null blob?

Do you auto-commit, commit every <X> records, commit at end of batch? Do you use
'commit retaining' or something similar? What tools/libraries/layers are between
the client and the database, that might need to be configured?

Is this a new problem? Can you pin it down to just a few operations, and if so,
can you give us a better idea of what you're doing?

-Philip