|Subject||RE: [firebird-support] problem with insert|
> Now I begin the transaction, run through the insert 260 times, thenEach "transaction" required a committ or rollback.
> commit the transaction
> Here are my Q's
> 1. Is there an effective limit on the number of transaction before
> calling commit,
I think you meant;
"Is there an effective limit on the number of **statements/operations**
before calling commit?"
Using FB v1.0 I would have suggested that the limit would be 10,000
operations, generally performance degraded beyond that.
With v1.5, there was work done to optimize this area of the engine, so I
don't any limit with that version.