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

<*> To visit your group on the web, go to:

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    (Yahoo! ID required)

<*> To change settings via email:

<*> To unsubscribe from this group, send an email to:

<*> Your use of Yahoo Groups is subject to:

  • [firebird-supp... fabia...@itbizolutions.com.au [firebird-support]
    • Re: [fire... fabia...@itbizolutions.com.au [firebird-support]
      • RE: [... Omacht AndrĂ¡s aoma...@mve.hu [firebird-support]
      • Re: [... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
        • R... fabia...@itbizolutions.com.au [firebird-support]
          • ... hamacker sirhamac...@gmail.com [firebird-support]
        • R... fabia...@itbizolutions.com.au [firebird-support]
    • Re: [fire... hamacker sirhamac...@gmail.com [firebird-support]
      • Re: [... 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]
        • R... hamacker sirhamac...@gmail.com [firebird-support]
          • ... 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]

Reply via email to