[fpc-pascal] Firebird: bulk insert performance: suggestions?
ludo.brands at free.fr
Fri Sep 7 13:22:21 CEST 2012
> 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
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.
More information about the fpc-pascal