I'm having a website built similar to Ebay that will allow users to exchange items. The data will be all text based. There is no telling how much info will have to be stored. Let's just say 100,000 items a year. Plus all the info for about 50,000 users a year. I would rather have just one as this is cheaper when it comes to hosting. I was told it is better to have multiple MySQL databases rather than having just one because access times will be quicker. Is there truth to this? Any opinions? Thanks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How many MySQL databases to use? 1
- Thread starter sazebac
- Start date
-
1
- #2
sleipnir214
Programmer
As a good general rule, I use a single database for any application.
As far as the multiple connection/speed issue goes, I don't know. Unless you are expecting to steal significant market share from eBay any time soon, the little bit of speed increase you get out of two databases and two connections is likely not economically justifyable.
Want the best answers? Ask the best questions: TANSTAAFL!
As far as the multiple connection/speed issue goes, I don't know. Unless you are expecting to steal significant market share from eBay any time soon, the little bit of speed increase you get out of two databases and two connections is likely not economically justifyable.
Want the best answers? Ask the best questions: TANSTAAFL!
- Thread starter
- #3
- Status