Hi, I had a similar problem to yours fairly recently. It was a
simple oversight on my part and probably not the same as the cause of
your problem. I was creating a connection in a thread and forgeting
to close the connection before freeing the thread, so try double-
checking that all connections are properly closed.

cheers, Terry

--- In firebird-support@yahoogroups.com, Szakály Balázs
<szakalyb@f...> wrote:

> Hi!
>
> We operate a server somewhere.
>
> There are ~10 simle user with ~20 database connection. This users

run ~10SQL/minute. (select * from..., update, etc) from a Delphi

> app.
> And there is 1 process which use ~10 database connection, and run

~70SQL/minute (50 select and 20 insert)

>
> The performance decrease in 3-4 days until a simple select takes 7

second (which is othervise ~100msec). Then i restart the server

> and performance restored.
>
> Where i need look for the problem?
>
> System: XP prof, Firebird 1.5 Final, Borland DBExpress driver
>
> sorry my english...
>
>
> szakalyb@f...
>
>
> [Non-text portions of this message have been removed]