Jump to content


Setingup an database for website.


  • Please log in to reply
2 replies to this topic

#1 Guest_daleosmond_*

Guest_daleosmond_*
  • Guests

Posted 13 April 2006 - 12:07 PM

Hey,
Right now I am going to start making an website a bit like my$pace.
my site offing free space, forums and accounts (of course) and in the future I might progress and add new services but my main question is shall I keep it all in one database or multiple but the sites user accounts will be used all over the site.

It would be greatly appreciated if you guys could give me some ideas on what to do.


#2 jworisek

jworisek
  • Members
  • PipPipPip
  • Advanced Member
  • 112 posts

Posted 13 April 2006 - 02:42 PM

if you are keeping the database relational (Which I assume you are) I don't see why one database wouldn't be fine. As far as I know there isn't any real limit to tables in a database (I could be wrong).

If you are trying to do a project like myspace though (depending on how many users you have) you might eventually need to think about multiple servers and load balancing.

#3 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 13 April 2006 - 08:19 PM

One database is definitely preferable -- obviously, if you have thousands of tables, then there's a slight overhead for the actual I/O operation that opens & closes the files that represent the MyISAM tables. Otherwise, the only issue of all of these tables will be open simultaneously is tuning the table_cache size appropriately.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users