Hi Riaan

> One of our Delphi SOAP applications makes uses a Firebird 1.0.3
> database. From when the server is started, the Firebird server
> process uses an increasing amount of memory and also shows

increased

> Here is some further information: This problem has been found on
> both the Win2K and Linux Superserver platforms (for the database
> server). We are using dbExpress data access components. The
> database configuration has automatic housekeeping disabled (0),
> Forced Writes turned off, 4K page size and 16384 pages.

Connections

> are pooled (on average, around 5 simultaneous connections found).
> There is only one UDF registered (strlen from IB_UDF), but it is

not

> used currently.

We found a similar problem using pooled connections in Java, it
turned out we wern't closing all the statement objects correctly,
leading to massive memory loss.

Try closing pooled connections occasionally to see if that fixes it,
we close about once every 500 connection usages just to catch any
problems we have missed. It is likely that your problem relates to
database access components being created but not freed correctly.

Regards
Ian Newby