We don't use LIST() and we have very few blobs in our database. The largest process in our database generates about 2000 records.

We use CommitRetaining in some case but not very much. Very most of our processes are small and we don't need to use auto-commit on them

We use IBExpress components which comes with Delphi, and we have no 3rd party layers in our application.

----- Original Message -----
From: unordained
To: firebird-support@yahoogroups.com
Sent: Tuesday, October 21, 2008 2:28 PM
Subject: Re: [firebird-support] Memory Problem


---------- 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




[Non-text portions of this message have been removed]