MySQL Forums
Forum List  »  Newbie

Speed - which would be faster
Posted by: statline
Date: March 24, 2005 03:38PM

I'm trying to create a fast database using MySQL, but I'm not sure how to give it the max power available.

If I have thousands of Select statements per minute should I:


Use 1 large table with all the data (40k - 60k entries)

or

should I use 1000 tables with less data in each table

Will one method be much faster than the other.

As well, should I use MyISAM or InnoDB tables ?

Thanks for the input

Sincerely
RG

Options: ReplyQuote


Subject
Written By
Posted
Speed - which would be faster
March 24, 2005 03:38PM


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.