RE: Performance question

From: <ryan.gaffuri_at_comcast.net>
Date: Wed, 23 Jun 2004 18:35:30 +0000
Message-Id: <062320041835.17482.40D9CD720000A06F0000444A2200734748079D9A00000E09D2020E979D@comcast.net>

I need my original question answered, how are you measuring 'rows/second.'

what periods of time are you getting 30 commits/second and what period of time are you getting 18 records/second?

btw, the slow down due to concurrency is understandable do to you committing so often.

also, let me understand your algorithm.

table1 has 1000 records in it. You full scan this and bulk collect it to memory. you do some processing in memory
you forall array insert 1000 records

you repeat. you are reading the same 1000 records each time?

---

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 - 13:32:23 CDT