I always check the active connections on server, when performance is poor: 20-30 user.... So, no unclosed session...unfortunately...


-----Original Message-----
From: Terry kahler [mailto:terry@...]
Sent: Monday, April 19, 2004 1:48 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Firebird 1.5 performance decrease in 3-4 days

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]



------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon
or Lexmark Printer at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/67folB/TM
---------------------------------------------------------------------~->


Yahoo! Groups Links