Subject RE: [firebird-support] Batch insert performance
Author Rick Debay
There is no support on the server for batching commands. This has been
brought up on the Firebird Java mailing list, as Jaybird currently fakes
the JDBC batch statements by sending commands one-at-a-time to the
Given that the Firebird network protocol is very chatty, it would be a
good thing to have.

-----Original Message-----
[] On Behalf Of Richard Wesley
Sent: Wednesday, August 23, 2006 5:03 PM
Subject: [firebird-support] Batch insert performance

Are there any tricks to getting good performance with FB when doing
batch inserts? I am getting about 1e6 rows/hr creating an 8e6 row table
which seems rather slow. The insert is being done in a loop with a
prepared statement before any indexes are created. Would batching the
inserts improve things?

(This is with FB2 RC3, but I am hoping the answer is more general.)

Richard Wesley Software Engineer
Tableau Software hawkfish
tableausoftware com


Visit and click the Resources item on the
main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at


Yahoo! Groups Links