Re: Optimize Insert

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Wed, 12 Jan 2005 08:33:26 -0800
Message-ID: <41e5502d$1_2@127.0.0.1>

Sascha Bahl wrote:

> In article <41e3ff0a$1_1_at_127.0.0.1>, damorgan_at_x.washington.edu says...
>

>>Sascha Bahl wrote:
>>
>>
>>>Hello!
>>>
>>>How can i optimize inserts into table? Under MySQL i can use value lists
>>>to collect many of records. How can i insert many of record in one
>>>insert statement?
>>>
>>>Thanks
>>>
>>>Sascha Bahl
>>
>>BEGIN
>> INSERT
>> INSERT
>> ...
>> COMMIT;
>>END;
>>/
>>
>>

> 
> 
> Thank you! My data import is faster now. From 20 min to 6 min.

Now lets try to get it down to less than one minute.

BEGIN
    INSERT /*+ APPEND */ ...
    INSERT /*+ APPEND */ ...
    ...
    COMMIT;
END;
/

Make sure you read up on the APPEND hint at http://tahiti.oracle.com and that it is applicable in your system.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---

Received on Wed Jan 12 2005 - 10:33:26 CST