Skip to Main Content
Forums

Database Software

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!

Insert very slow with the cause of dupplication key

757106Mar 1 2010 — edited Mar 3 2010
Hi,

I face some problem when insert data to Timesten database.
If no PK duplicate, it will take about 4-5 ms.
But if can not insert cause duplicate primary key, it will take more than 10 seconds to return error.

Data to insert about 1 million records and my database is a replication.

Anyone could help me diag this problem. I'm a very new Timesten DBA.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 31 2010
Added on Mar 1 2010
#database-key-features, #timesten-in-memory-database
5 comments
3,099 views