Re: MySql Horizontal partitioning - Pros-Cons
Posted by:
Rick James
Date: April 17, 2014 11:16PM
> And also is there any alternate solution for partitioning to get performance improvement and data separation.
First, let me dispel the myth that PARTITIONing will automatically give you a performance improvement. There are a limited number (about 3) of use cases for which PARTITIONing gives any perf. Please describe your dataset, and why you think partitioning might help.
Second, I question whether you really need FOREIGN KEYs in a production system. The code should be thoroughly QA'd such that the FK checks never find a problem with data integrity. Any CASCADEing can be done in code, or buried in Stored Procedures, or a "database layer" between the end-users and the server.
And... FOREIGN KEY checks are a performance hit.
Subject
Views
Written By
Posted
4790
April 14, 2014 11:43AM
Re: MySql Horizontal partitioning - Pros-Cons
2415
April 17, 2014 11:16PM
1803
April 19, 2014 03:42PM
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.