Subject Re: Transaction gap
Author Aage Johansen
"Michael Vilhelmsen " wrote:
> When starting in the morning the gab between OAT on NT is 1.
> During the day this grows up to somewhere between 100 and 2000.
> At the end of the day, when everybody logs out, ends there program
> etc, the gab comes back to 1.
> When its this way, then the programs behave normally, correct ?


"Normal"?. They could behave better, though.
One or more of the programs connected to the database keep a transaction
open for a long time. Do the programs commit often, seldom, hardly ever?
Is someone connecting and watching the db during the day (keeping his tx open)?


Regards,
Aage J.