Skip to Main Content

Berkeley DB Family

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Urgent. Why insertion performance is so poor when insert 100k records?

804968Oct 12 2010 — edited Oct 12 2010
Hello All,

I am working on an experiment involving insertion 1 million records to BDB. But when I insert 100k records, the insertion becomes very slow, almost 1 sec per record.
Is there some way to improve the insertion performance?

In my case, I created primary database and secondary database. All the data inserted to primary database are sorted according the key already.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 9 2010
Added on Oct 12 2010
1 comment
272 views