Well, I wrote that scripts by isql.exe < script.sql is more fast than
transfer from machine to another because... I did and compare.
Is more fast because dont depends of any kind of application that use data
layers(ado, odbc,...) and network protocols, it´s more similar that 'bulk
insert' in
hoogroups.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, fabia...@itbizolutions.com.au [firebird-support] wrote:
>> Does anyone have experience with bulk updates via isql? Woul
Script is just a bunch of SQL statements executed in sequence. An
insert script will never be faster than using prepared parametrized
statements, since with scripts, Firebird will have to prepare/execute
statements one by one.
For specific cases, user may try to put the "inserts" inside an
would fly, right??
>
> Cheers,
> Fabian
>
>
>
> - Original Message -
> From: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]"
> <firebird-support@yahoogroups.com>
> To: <firebird-support@yahoogroups.com>
> Sent: Wednesday, May 16
ebird-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, fabia...@itbizolutions.com.au [firebird-support] wrote:
>> Does anyone have experience with bulk updates via isql?
I dont know bulk method in firebird.
You can write scripts, scripts is more fastest than transfer from machine
to another. You can run isql.exe < script.sql
If is not possible to create scripts then use (hard) commit each 1000 (or
more) transfers, if you not to do, transaction will be slowing at
16.05.2018 4:48, fabia...@itbizolutions.com.au [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
support@yahoogroups.com>
Sent: Wednesday, May 16, 2018 12:43 PM
Subject: [firebird-support] Bulk upload options
>I am looking for the fastest way to run a bulk insert.
> I believe one way would be using isql.exe , I need to plan a solution to
> upload into a single table around 500 millio
I am looking for the fastest way to run a bulk insert.
I believe one way would be using isql.exe , I need to plan a solution to
upload into a single table around 500 million records. Does anyone have
experience with bulk updates via isql? Would it be X times faster than using a
normal
10 matches
Mail list logo