I take it that you don't have any UDFs either, that your tables aren't external tables and that there's nothing else that can be of importance either (e.g. do you use Blobs?). You haven't mentioned any keys in the tables, I take it that you do use primary keys and possibly generators (ah, looking at your description you don't have any triggers, so that means no triggers for assigning primary keys)?

What's the database statistics like (that's a more reliable way to deem that there's no transaction that keeps things from moving on)? Which Firebird version are you using (both server and client), how do you access Firebird (IBO, IBX, something completely different) and what operating system?

160000 inserts and deletes per day doesn't sound too much, do each of them happen in separate transactions or are there several inserts/deletes per transaction?

It is normal that the file size increases at first, but after a while it should start reusing empty space. So if the file size keeps increasing day by day, you have no long running transaction and empty the database each day, then I'd say there's something that isn't right.

Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Johanny Bergeron
Sent: 15. oktober 2008 09:15
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Memory consumption / Database file size

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