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

zhanggp wrote:
> i have to insert millians 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!!
> thanks a lot
>
>

Is the problem in other areas? fragmented tablespace? What is the frequency of commits?

Just guessing. you did say millions of records. Per day?

-- 
Ed Prochak
running: http://www.faqs.org/faqs/running-faq/
family:  http://web.magicinterface.com/~collins
--
"Two roads diverged in a wood and I
I took the one less travelled by
and that has made all the difference."
robert frost