Partitioning for improving "INSERT .. ON DUPLICATE KEY UPDATE"
Posted by:
Jon Jacob
Date: July 20, 2014 07:50AM
Hello,
I'm performing ~7 million "Insert ... On Duplicate Key Update" statements on a table.
At first I'm getting like ~1000 executed queries per second
Toward the end it has slowed down to ~1 per second...
The table in question has two fields that are unique keys:
date (text as yyyy-mm-dd)
pageid (numeric)
The update portion simply increments a counter field if there is already a date/pageid present.
Could a partition help with the degraded performance? I'm still reading up on how a table partition differs from a field index, but that's another topic. But am I barking up the wrong tree thinking partitions would help with this scenario?
Subject
Views
Written By
Posted
Partitioning for improving "INSERT .. ON DUPLICATE KEY UPDATE"
2923
July 20, 2014 07:50AM
1629
July 21, 2014 06:50PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.