[fpc-pascal] Firebird: bulk insert performance: suggestions?

[Ludo Brands]

> For my Dutch postcode program https://bitbucket.org/reiniero/postcode
> with an embedded Firebird 2.5 database, I allow users to read 
> in a CSV file with new or updated postcode data. I use sqldb, 
> FPC x86. I'd like to get your suggestions on speed improvements.
> 

Turn of indices when inserting and turn them on again when the inserting is
done.

Since you are the only user and concurrent access is not that important (I
guess), I believe isc_tpb_concurrency is not the best choice. IIRC
isc_tpb_read_committed + isc_tpb_no_rec_version has the less overhead. 

Ludo