Re: [Firebird-net-provider] Bulk Load Data into Firebird Embedded

[Dmitry A. <fd...@ua...>]

Hello Michael,

Thursday, April 22, 2004, 5:25:29 AM, you wrote:

MS> This is somewhat off topic, but has anyone found a way to bulk load 55,000
MS> rows into Firebird quickly?

MS> I'm currently doing it via a dataadapter.update with a custom InsertCommand,
MS> but it's taking almost 20 minutes.

MS> So, in short... what's the easiest way to load 55,000 rows into Firebird.
MS> Each row is only about <300 bytes.

MS> My table has 8 columns w/ 1 auto number column, and no indexes.
    Any way if you want maximal performance in firebird - you must
    execute inserts in one transaction per 200-500-1000 records, no
    more. 

-- 
Best regards,
 Dmitry                            mailto:fd...@ua...