Subject | RE: [firebird-support] Re: Firebird 1.5 performance decrease in 3-4 days |
---|---|
Author | Szakály Balázs |
Post date | 2004-04-20T18:19:31Z |
This is a new gstat's report, when the server performace is poor.
I see Oldes Active.... I think, this is a problem.
But, if i stop all app, which connecting to Firebird, i see that still are 10 user connection to database... I wait 10 minutes, the
connctions stopped.
On my app is an internal statistic, whether who much active connection is to database. I counted it and checked on IBConsole the
active connections, and the connections more than my app's connect. I think that the Borland DBExpress driver not close correctly
the firebird connection.
Or bug on my prog :)
Flags 0
Checksum 12345
Generation 2206323
Page size 16384
ODS version 10.1
Oldest transaction 1362491
Oldest active 1362495
Oldest snapshot 1362492
Next transaction 2206316
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Mar 24, 2004 17:49:50
Attributes force write
Variable header data:
Sweep interval: 20000
*END*
I see Oldes Active.... I think, this is a problem.
But, if i stop all app, which connecting to Firebird, i see that still are 10 user connection to database... I wait 10 minutes, the
connctions stopped.
On my app is an internal statistic, whether who much active connection is to database. I counted it and checked on IBConsole the
active connections, and the connections more than my app's connect. I think that the Borland DBExpress driver not close correctly
the firebird connection.
Or bug on my prog :)
Flags 0
Checksum 12345
Generation 2206323
Page size 16384
ODS version 10.1
Oldest transaction 1362491
Oldest active 1362495
Oldest snapshot 1362492
Next transaction 2206316
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Mar 24, 2004 17:49:50
Attributes force write
Variable header data:
Sweep interval: 20000
*END*