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