The app uses the BDE to connect to the database and do its work.

We call TDabase.Commit inside a try except block, the exception handles
calling Tdatabase.Rollback.

I am not too sure what you mean by autocommit and hard commits.

The databases have forced writes enabled, and we seem to handle
ApplyUpdates, CommitUpdates in the Tquery objects, then call a
Tdatabase.Commit.

Is there something else we should be doing, if so please please please
tell me as my customers are also rather annoyed with having to be taken
down (they are 24/7 medical operations) to backup and restore....

Thanks for any help..

-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: 02 December 2003 11:16
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Who's guilty?

At 09:36 AM 2/12/2003 +0000, you 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 ,

I suppose you do understand that, if commit fails, your application will
have to handle the failure...

..and that Autocommit prevents the record versions from the involved
transactions from being made "uninteresting"...

>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..

1 million Autocommits and no hard commits?

/heLen




To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/