Jump to content


Photo

Does It Matter


  • Please log in to reply
2 replies to this topic

#1 jaymc

jaymc
  • Members
  • PipPipPip
  • Advanced Member
  • 1,521 posts
  • LocationLiverpool

Posted 22 September 2006 - 01:07 PM

I have a database which contains my members table and a few other things. The members table is heavily accessed..

I am going to make 2 more tables which will be heavily used

My question is, will it slow things down if I put the 2 new tables in the same database as the members database

Would it be better making a new database for the 2 new tables?

Or doesnt it matter?

Thanks
I would love to change the world, but they won't give me the source code

SEO Agency

#2 Daniel0

Daniel0
  • Staff Alumni
  • Advanced Member
  • 11,956 posts

Posted 22 September 2006 - 03:00 PM

I would strongly suggest you to keep it in the same database, or you will have to run mysql_select_db() a lot of times.

#3 fenway

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

Posted 25 September 2006 - 02:33 AM

I've only encountered 2 or 3 real-world applications that actually required a second database, so the answer in your case is probably no.
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