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

Martin Schreiber mse00000 at gmail.com
Sat Sep 8 07:31:09 CEST 2012


On Saturday 08 September 2012 01:05:28 Graeme Geldenhuys wrote:
> On 07/09/12 12:12, michael.vancanneyt at wisa.be wrote:
> > I once did tests with that (600.000 records) and did not notice any
> > influence of the transaction control.
>
> Same here... I've imported 100's of thousands of records with
> SqlDB+Firebird with no serious speed issues. Also from CSV files.
> Transactions are always used.
>
It depends on the reaction time of the network because AFAIK there is a 
roundtrip for every inserted record...

Martin



More information about the fpc-pascal mailing list