Ghazanfar Ali wrote:

>Hello Everyone and the repliers,
> I was using isc_dsql_execute previously for that i was preparing the statement, but now i am using isc_dsql_execute_immediate with no statement preperation, it has reduced the memory leaks from 80MB to 10MB for 100 records insertion. But still i am having that 10 MB leak, one thing i want to tell is that when i detach from the database all that extra memory has been properly released...
>

It's not a leak. Superserver by default allocates 2048 pages for each
database. Your database is, probably, using 4K pages. 2K x 4K = 8MB
aproximately the memory you think is leaking.

> Ghazanfar.
>
>

Ivan.