[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