MySQL Forums
Forum List  »  Partitioning

Re: The only concern is whether referenced tables can be partitioned?
Posted by: Rick James
Date: February 27, 2009 12:24AM

One of us is quite confused. I will assume you are confused about the meaning of "partition". Partitioning that is discussed in this forum has to do with a way of splitting up a "table" into "partitions".

Are you are providing a service where different clients get different datasets, and you don't want them to see each other's data (for security reasons)? This is how I would intepret "information for a specific client". For this you really need to have separate databases.

If you are splitting data _about_ each client, then a "client_id" column can say which client this row is referring to.

Neither of these interpretations involve "partitions".

(Sorry that the English language is so tricky.)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: The only concern is whether referenced tables can be partitioned?
3040
February 27, 2009 12:24AM


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.