Subject | Re: Transaction gap |
---|---|
Author | Aage Johansen |
Post date | 2003-01-13T20:44:51Z |
"Michael Vilhelmsen " wrote:
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.
> When starting in the morning the gab between OAT on NT is 1."Normal"?. They could behave better, though.
> 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 ?
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.