once again my pro*c question

i have to insert millions of records into one table a day. every record is perhaps 512 bytes.
i use pro*c 's bulk insert like 'exec sql for :n insert ', and the table has a primary index and serveral 'not null' constraints. at first it inserts 100 records per seconds and after a day it inserts 30 records per seconds.
i dont know how slow it will be after a week! Does anyone have the idea how to improve the performance? thanks a lot Received on Wed Mar 05 2003 - 23:35:04 CST