Subject Batch insert performance
Author Richard Wesley
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