Re: Performance question

From: <ryan.gaffuri_at_comcast.net>
Date: Wed, 23 Jun 2004 14:32:37 +0000
Message-Id: <062320041432.1509.40D9948500026717000005E52200758942079D9A00000E09D2020E979D@comcast.net>

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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Jun 23 2004 - 09:29:30 CDT