Re: Performance question
- From: ryan.gaffuri@xxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 23 Jun 2004 14:32:37 +0000
comments inline....
> Hi,
>
> Scenario overview
> ------------------
>
> We are testing an application prototype and inserting 1000 rows at a
> time from 1 table and populating into 2nd table in a loop and inserting
> 1M rows. 2nd table have primary key on 2 column, 1 column unique key and
> 2 non-unique indexes each having 6 columns. This is 10g on WIN2K.
This is not exactly clear...
are you doing the following
For x in (select stuff from table)
insert 1000 rows
end loop
commit;
you are stating you can do 30,000 of those per second at one point? Please post
pseudo-code. Please do NOT post all of the real code, just an outline.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
