Subject Re: [ib-support] Re: Memory Usage
Author Ann Harrison
At 09:27 AM 3/28/2002 +0000, Ian Newby wrote:

>The database has been restarted and the memory usage is growing
>consistantly by about 20Meg per day.

Ugly. Is there any chance of running a debugging server?
Certainly others are running similar applications without
seeing this memory growth, so there's something else going

Do you use prepared statements? Do you release them? Does
your application ever disconnect?

>I thought Firebird couldn't use more than the buffers * pagesize of

No. Or rather, you may have thought that, but it's not the case.
The number of page buffers - database pages that can be held in
cache - is fixed but lots of other things cause Firebird to allocate
heap memory. It's got a moderately sophisticated memory manager
so it should reuse memory that's been released... so I'm looking
for something that might be kept around inadvertently.