Re: how to improve the performance of insert in pro*c

From: Mark Stratford <mark_stratford98_at_yahoo.co.uk>
Date: 6 Mar 2003 09:33:57 -0800
Message-ID: <690213b6.0303060134.701c2f5e@posting.google.com>

"zhanggp" <zhangguoping_at_boco.com.cn> wrote

> i have to insert millions of records with one record 512 byte one day.
> i use pro*c 's array insert, and the table has a primary index and serveral
> not null constraints.
> at first it works with 100/s and after a day it works with 30/s.
> i dont know how slow it will be.
> who has the idea how to improve the performance!!

Can you not bother with pro*C but use SQL Loader instead ...?

mark stratford Received on Thu Mar 06 2003 - 11:33:57 CST