Re: inserting many records with ADO is very slow

From: wario <wario_spam_at_insightbb.com>
Date: 15 Sep 2004 11:34:30 -0700
Message-ID: <962c6d85.0409151034.746db556@posting.google.com>

Your example would not be the optimal method to perform bulk update/insert into a database.

1. Create a pl/sql block to perform changes.

    begin

        execute immediate 'DROP   TABLE SCOTT.TEST';
        execute immediate 'CREATE TABLE SCOTT.TEST (NAME
VARCHAR2(750))';
        
        insert into scott.test  (name)
            select name  from table_a;

        commit;        

    end;

2. Better yet. Use SQL Loader to insert all your data into a table used for transactions. Then use MERGE, INSERT or UPDATE to update/insert changes to main table. Received on Wed Sep 15 2004 - 13:34:30 CDT