Subject Re: [firebird-support] Who's guilty?
Author Aage Johansen
On Tue, 2 Dec 2003 09:28:19 +0000 (UTC), Martin Dew wrote:

> I have similar issues with some of my sites using IB5.6 and IB6.0.2.0,
> I cannot replicate this in my test rig, and I have checked my commiting
> code numerous times to make sure I am always calling either a .commit or
> a .rollback , but I get I huge gaps in transaction statistics, I cannot
> do a sweep as the gap is not between the OIT and OAT (see example) so my
> only option is a backup and restore. I have tried IB_AFFINITY to set it
> to one processor in the dual processor machine, I have also had the IT
> team turn off hyperthreading in the bios, all to no avail.
> OT 566738
> OAT 566739
> NT 940551
> OS 564916
> After checking this weekend the OT,OAT and OS have not moved from above,
> but the NT is now more than a gap of 1 million to these other stats..

You are using "commit" and the BDE? Isn't the hard/soft commit determined
by some option flag in the BDE (SQLlinks)? If so, you may well believe
you're doing 'hard commits' while the BDE is doing its own thing.

Aage J.