MySQL Forums
Forum List  »  Partitioning

Re: PARTITION or sEPERATE tABLE ISSUE
Posted by: Rick James
Date: October 30, 2009 09:35AM

1) -- Single table. Or perhaps a single set of tables. Are the N records similar? Or are they describing different things? And perhaps some are optional, or come multiple times for a vehicle? Generally, make different tables for different types of data.

2) Millions of records -- not big enough to consider partitioning or sharding.

To answer the rest of your concerns, let's see the schema (table design), give us a hint of how big N is; etc.

MySQL can normally insert a few hundred rows in 3 seconds.

Options: ReplyQuote


Subject
Views
Written By
Posted
3351
October 29, 2009 06:32AM
Re: PARTITION or sEPERATE tABLE ISSUE
2131
October 30, 2009 09:35AM


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.