firebird-net-provider

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

[Michael S. <ms...@ro...>]

Hi all,

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

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

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

My table has 8 columns w/ 1 auto number column, and no indexes.

Thanks!
-- 
Michael She  : mic...@bi...
Mobile       : (519) 589-7309
WWW Homepage : http://www.binaryio.com/

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...

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

[<car...@te...>]

Hello:

> This is somewhat off topic, but has anyone found a way to bulk load 
> 55,000
> rows into Firebird quickly?
>
> I'm currently doing it via a dataadapter.update with a custom 
> InsertCommand,
> but it's taking almost 20 minutes.
>
> So, in short... what's the easiest way to load 55,000 rows into Firebird.
> Each row is only about <300 bytes.

Huummm have you tested it with prepared statements ?? Can you post a 
snippet
of the code you are using ??

Are you using 1.5 or 1.6 version ??





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

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

[Mike S. <mi...@mi...>]

Hi Michael

Transform your input data into fixed width format then open it in 
Firebird as an external file and do a select from it into your Firebird 
table. Search the Interbase 6.0 docs for "external file" but 
specifically see the Interbase Data Definition Guide, page 107.

Cheers,

Mike.

Michael She wrote:

> Hi all,
>
> This is somewhat off topic, but has anyone found a way to bulk load 
> 55,000
> rows into Firebird quickly?
>
> I'm currently doing it via a dataadapter.update with a custom 
> InsertCommand,
> but it's taking almost 20 minutes.
>
> So, in short... what's the easiest way to load 55,000 rows into Firebird.
> Each row is only about <300 bytes.
>
> My table has 8 columns w/ 1 auto number column, and no indexes.
>
> Thanks!