Re: Multiple Tables Split By Date
Posted by: Rick James
Date: February 25, 2013 11:48PM

Once your data is much bigger than your cache, UUIDs slow down inserts to about 100/sec. This is because of their random nature, and your need to add them to an index(es). (60M rows would take 1 week to load if you need to update 1 UUID index. RAID striping would help.)

I avoid a lot of problems by never writing to both Masters at the same time. I deal with several systems that have dual-master (but only one is written to) and PARTITIONed tables. I can't imagine what kind of problem "some people" are having.

Options: ReplyQuote


Subject
Written By
Posted
February 20, 2013 05:40AM
February 21, 2013 11:23PM
February 23, 2013 12:10PM
Re: Multiple Tables Split By Date
February 25, 2013 11:48PM


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.