Subject Re: [firebird-support] Embedded Firebird : Transaction
Author Nando Dessena

>> - commit every "n" inserts, where "n" is usually in the thousands.

BHS> That exactly what I'm trying to do. Speed (or lack thereof) in my case
BHS> is clearly due to Firebird I/O. I'm not a firebird expert (obviously),
BHS> but if the only way to achieve this is through transactions, and
BHS> transactions requires API calls, well I'll just have to wait.

Couldn't you add a simple pre-processing phase to your SQL execution
engine that understands START TRANSACTION, COMMIT and ROLLBACK and
maps them to the corresponding API calls? AFAIK that's what ODBC and
other tools do. That's also what isql and any tools capable of running
Fb scripts do. Even FlameRobin.

BHS> Oh, and thanks for your tool, it's a life saver.

And it's fun to work on it too. ;-)

Nando Dessena