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
server.
Given that the Firebird network protocol is very chatty, it would be a
good thing to have.

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Richard Wesley
Sent: Wednesday, August 23, 2006 5:03 PM
To: firebird-support@yahoogroups.com
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.)

TIA,
________________________________________________________
Richard Wesley Software Engineer
Tableau Software
http://www.tableausoftware.com/ hawkfish
tableausoftware com





++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item on the
main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links