Subject Re: [IBO] Transactions
Author Robert martin

We have a BDE app that has been converted to Firebird. We have used IBO
components with Auto commit. However We are implementing proper
transaction handling. as in the previous email thread (Im back from
holiday now).

We have a large processing block that I have surrounded by one
transaction as if any part fails we want to rollback and retry. However
the process is now much slower! With autocommit and default IBO
transaction it takes about 0.4s to process. With an explicit
starttransaction / commit it now takes 11s !!!

I have run gStat which returns the following...

Database header page information:
Flags 0
Checksum 12345
Generation 31654
Page size 8192
ODS version 10.1
Oldest transaction 31597
Oldest active 31598
Oldest snapshot 31592
Next transaction 31647
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 9000
Next header page 0
Database dialect 3
Creation date Oct 25, 2005 11:20:54
Attributes force write

Variable header data:
Sweep interval: 20000

Which seems OK.

What am I doing wrong ?

Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496

Wild Software Ltd