Hello,

yes, we use also long running read only transactions - one visualisation
takes the values of the tables and shows it - some char fields - every 5
seconds the visualisation refresh the view for fields. (high bay storage)
One procedure looks for new orders - if not so, it looks after 10 seconds
again - but with no chars returning.

We don't use the list function.

Thanks for your ideas.

________________________________________
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Im Auftrag von Dmitry Yemanov
Gesendet: Mittwoch, 22. April 2009 11:36
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] Problem Firebird 2.1 Superserver




Olaf Kluge wrote:

>
> It looks fine, but the process fbserver takes hour to hour more RAM from

the

> system. From yesterday to this day increases the size from 300 Megabyte to
> 500 Megabyte. The firebird-process-size increases minutely more and more.
>
> The pagefile increases too. The problem is, that firebird jbird driver
> returns after one week of running firebird an error message, that firebird
> cannot allocate more memory.
>
> What can be the problem?

Do you have any long-running read-committed read-only transactions?
If so, do they work with blobs? Do you use the LIST function anywhere in
your queries or procedures?

Dmitry