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.