Hello,

thank you.

Can I see in the monitoring tables what increase the memory requirements?

It is a mean database with some tables and stored procedures, we are not
using udfs. Sadly, there are some char-fields in our database. It is now my
part, but the database is not developed by me.

Three different clients connect to the firebird database (java netbeans with
jaybird) (the whole time)

I will test it, if the firebird gives the memory free after I have
disconnected some clients.

> What can be the problem? How can I find and solve it?

This is definitely resources leak. May be caused by virtually
anything in your system. AFAIU you have application always connected to
server, so to such usual source of leaks as bad UDF, we may add not
freeing such connection-long resources as statement handles and,
probably, temporary BLOBs.
Check if memory consumption return to normal if you disconnect all
clients from server.

SY, SD.


------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links



No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.287 / Virus Database: 270.12.1/2071 - Release Date: 04/21/09
08:30:00