--- In firebird-support@yahoogroups.com, "Dimitry Sibiryakov" <SD@t...

> wrote:
>
> On 12 Jan 2006 at 13:00, pi3k14 wrote:
>
> > AND EXISTS( SELECT *
> > FROM HentDimSaldoBalanse( 'B', Bunke.

Id

> > )
> > WHERE Dimensjoner = :Dimensjoner )
> >
> >It is the EXISTS statement that "breaks the server", it seems like

it

> >consumes a lot of memory for each invocation. HentDimSaldoBalanse

is

> >simplified to just return the string '#'.
>
> That's it! FB1.5 has a bug with growing memory consumption when
> selectable SP is called from PSQL or subquery. This memory is
> released only on commit of transaction if I'm not mistaken.
>
> --
> SY, Dimitry Sibiryakov.
>

Thank you,

now I know the disease and can make a cure :)

frode