I am not sure API memory management is clean.
I use about 150 different selects in non-stop client.
For few days the size of my application increased from 2 Megs to 5.

"Ann W. Harrison" wrote:

> At 11:44 PM 2/10/2002 +0300, Lev Assinovsky wrote:
>
> >Each nested SELECT allocates approx 24K - which is never returned.
>
> This is probably incredibly obtuse (i.e. stupid) of me, but
> preparing a statement causes memory to be allocated in the
> server to hold the compiled version of the statement. The
> amount of memory is related to the record size of the table,
> the size of the data returned, and the complexity of the query.
>
> The memory is released to the server when the request is
> released. Firebird/InterBase never return memory to the
> system on the assumption that some other connection will
> want to use memory and reusing allocated memory is cheaper
> than reallocating it.
>
> Regards,
>
> Ann
> www.ibphoenix.com
> We have answers.
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

--
Lev Assinovsky Peterlink Web
Programmer St. Petersburg, Russia
Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7�
E-mail: lev@...




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