| Subject | Firebird 1.5 performance decrease in 3-4 days |
|---|---|
| Author | Szakály Balázs |
| Post date | 2004-04-16T15:40:34Z |
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@...
[Non-text portions of this message have been removed]
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@...
[Non-text portions of this message have been removed]