Subject | RE: [firebird-support] slow database ref/eDN8022297953 |
---|---|
Author | dennis |
Post date | 2008-06-13T14:31:24Z |
Can somebody tell me the meaning of the follow terms of gstat?
I checkout when the follow counters how they changed during database use and
I couldn't figure out what is happening and what they really mean.
Oldest transaction
Oldest active
Oldest snapshot
Next transaction
I did this test, I worked with ibexpert a database, I get the stat and then
with my application and I compare the differences of these counters. You can
see them on the attached xls. I couldn't discriminate how the counters
should be. Both applications, more or less modified the counters with the
same way. Do they both manage the transactions wrong?
Please provide values for these counters when an application handles correct
the transactions for long time.
Also please explain this gstat's counters:
Oldest transaction 1007
Oldest active 1008
Oldest snapshot 1008
Next transaction 18504685
What really means this extreme difference?
Kind regards
Dennis
[Non-text portions of this message have been removed]
I checkout when the follow counters how they changed during database use and
I couldn't figure out what is happening and what they really mean.
Oldest transaction
Oldest active
Oldest snapshot
Next transaction
I did this test, I worked with ibexpert a database, I get the stat and then
with my application and I compare the differences of these counters. You can
see them on the attached xls. I couldn't discriminate how the counters
should be. Both applications, more or less modified the counters with the
same way. Do they both manage the transactions wrong?
Please provide values for these counters when an application handles correct
the transactions for long time.
Also please explain this gstat's counters:
Oldest transaction 1007
Oldest active 1008
Oldest snapshot 1008
Next transaction 18504685
What really means this extreme difference?
Kind regards
Dennis
[Non-text portions of this message have been removed]