Subject | Firebird 1.0.2SS transactions problem. |
---|---|
Author | anna_wiejak |
Post date | 2005-01-07T13:21:33Z |
Hello all,
Recently I have had a problem with firebird performance, so I went
deeper into firebird performance monitoring stuff. Unfortunately I
can't do much because thats an old poor version of firebird so
monitoring views are not available.
However I can use gstat against databases. I was suprised to see that
a number of propably uncomitted transaction in isc4.gdb security
database is very high:
Oldest snapshot 58
Next transaction 370887
The isc4.gdb contains only two records in users table. Is that
possible? Does this problem needs any further steps or should I ignore it?
Thanks for any suggestions,
--
Anna
Recently I have had a problem with firebird performance, so I went
deeper into firebird performance monitoring stuff. Unfortunately I
can't do much because thats an old poor version of firebird so
monitoring views are not available.
However I can use gstat against databases. I was suprised to see that
a number of propably uncomitted transaction in isc4.gdb security
database is very high:
Oldest snapshot 58
Next transaction 370887
The isc4.gdb contains only two records in users table. Is that
possible? Does this problem needs any further steps or should I ignore it?
Thanks for any suggestions,
--
Anna