Performance question

From: music4 <music4_at_163.net>
Date: Fri, 30 May 2003 08:59:02 +0800
Message-ID: <bb6ae0$k9c@netnews.proxy.lucent.com>

Greetings,

I am developing a OCI program in C language on Unix platform. And I have a thread that only "delete from" and "insert into" some table. Now, I do commit on success on each delete and insert. But I find this way cannot meet the performance required. So I am considering that to do several (for example 10 or 20 or 100) deletes and inserts than performance a commit. Could that way improve performance? If yes, how many percentage could be improved?

Thanks in advance!
Evan Received on Thu May 29 2003 - 19:59:02 CDT