Hi

This article explains the solutions to Bulk upload,

http://www.firebirdfaq.org/faq209/

Like Firebird FAQ already thought of many issues!!!!

Cheers,
Fabian

----- Original Message -----
From: "Dimitry Sibiryakov sd@... [firebird-support]"
<firebird-support@yahoogroups.com>
To: <firebird-support@yahoogroups.com>
Sent: Wednesday, May 16, 2018 7:10 PM
Subject: Re: [firebird-support] Bulk upload options


> 16.05.2018 4:48, fabianch@... [firebird-support] wrote:
>> Does anyone have experience with bulk updates via isql? Would it be X
>> times faster than using a normal application inserting the records inside
>> a begin transaction and commit at the end?
>
> No, because it is exactly what isql does: execute a prepared statement
> for each line of
> data. No magic inside.
>
>> I think this solutions will do!!!!
>
> External tables has a definite limitations, for example you cannot put
> NULL into it. If
> it is ok for you - fine. Otherwise the fastest way is export data into a
> file on one side,
> compress, transfer to other side, uncompress and then parse the file and
> insert records
> one-by-one in a single transaction.
> Firebird 4 has some kind of batch interface, but I'm not sure if it can
> speed up bulk load.
>
> --
> WBR, SD.
>
>
> ------------------------------------
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu. Try FAQ and other links from the left-side menu
> there.
>
> Also search the knowledgebases at
> http://www.ibphoenix.com/resources/documents/
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> ------------------------------------
>
> Yahoo Groups Links
>
>
>