Hello,

First, I must say that I don't do a typical usage of the database.
The database is used to store some data for 1 day maximum (really simple
db : 4 tables, 0 procedures, 0 triggers, some indexs), and the number of
records by table never gets really high (2000 max). But where Firebird
must be stressed is I am doing many insert and delete (around 40000 by
day for each table) + all the select queries. The client application
stay connected to the database server 24 hour a day.

The database is working good except 2 things that prevent me to have an
application stable for production (server or Firebird service must not
be rebooted !!)

-) The memory consumption of the Firebird process is increasing day
after day. My initial thought was I had forgotten to release some
transactions or queries in my application. However, even if all client
application disconnect, the memory don't go back to its initial state so
I think the problem don't come from client application.

-) The size of the database file keeps growing, even if the number of
records in the database don't grow (but many are deleted and new ones
inserted). Is it normal?

If someone could help, I would be very happy , Thanks :)

Johanny