> Now I begin the transaction, run through the insert 260 times, then
> commit the transaction
>
> Here are my Q's
> 1. Is there an effective limit on the number of transaction before
> calling commit,

Each "transaction" required a committ or rollback.


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.


Sean