> 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 _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
