MySQL Forums
Forum List  »  Newbie

Re: more Tables
Posted by: Phillip Ward
Date: June 20, 2016 06:21AM

Quote

I have to create a DB with n Tables. Each tables have the same number and name fields.

No you really, really don't.

Subdividing your data in this way is indicative of a poor Design and will not serve you well. Data Normalisation, sensible Keys and proper Indexing will handle the vast majority of performance issues that people think are solved by this kind of "manual" partitioning.

Regards, Phill W.

Options: ReplyQuote


Subject
Written By
Posted
June 19, 2016 11:39PM
Re: more Tables
June 20, 2016 06:21AM
June 23, 2016 07:02PM


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.