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
on.

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
>memory?

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.

Regards,

Ann