Re: Partitioning or Not Partitioning?
Posted by:
Rick James
Date: November 06, 2014 07:16PM
> What is? I don't see the answer, it's a spam?
What do you mean?
Your main problem is inserting 5000 rows per second. PARTITIONing will help that. Nor will having multiple tables. So, I am trying to direct your attention to the problem of input speed.
After that is resolved, we can get back to whether to PARTITION or not. Note: It is mostly SELECTs that determine the utility of PARTITIONing, not INSERTs.
Also, please tell us what type of disk system you have. RAID and SSDs can _partially_ help you achieve 5000/sec. But generally other techniques should be used.
Subject
Written By
Posted
November 05, 2014 12:11PM
November 05, 2014 04:53PM
November 06, 2014 02:57AM
Re: Partitioning or Not Partitioning?
November 06, 2014 07:16PM
November 07, 2014 02:07AM
November 08, 2014 05:10PM
November 12, 2014 05:33PM
November 17, 2014 11:32AM
November 19, 2014 04:42PM
November 20, 2014 04:53AM
November 21, 2014 08:26PM
November 24, 2014 07:30AM
November 24, 2014 07:21PM
November 25, 2014 04:35AM
November 25, 2014 11:45AM
November 25, 2014 11:55AM
November 29, 2014 03:42PM
November 24, 2014 05:14PM
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.