MySQL Forums
Forum List  »  Optimizer & Parser

Re: many databases or many tables
Posted by: Rick James
Date: November 20, 2010 09:28AM

One table can handle billions of rows, so why split it up?

With/without lots of tables, there is effort to get to the desired table versus making the search of the table a little faster/slower.

Keep it simple by not splitting into tables; the performance is not enough to matter; it may even make it slower.

Options: ReplyQuote

Written By
November 18, 2010 10:18PM
Re: many databases or many tables
November 20, 2010 09:28AM

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.