SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Wizard jag5311's Avatar
    Join Date
    Jan 2003
    Location
    Somewhere in Indiana
    Posts
    3,082
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Having two websites share the same database?

    So I am hosting with Jodohost. Since its a shared server, and my plan allows me to have 1 mysql database, could there be conflicts of having 2 sites utilize my resource of 1 mysql database? My sites are not overly big, one is in my sig, gamecubecheats.info and the other will be movable type based.

    One uses Coldfusion, I am thinking of either keeping my MT with coldfusion or maybe just switching to PHP for that. I am not sure if there is a better "combo" so to speak in regards to mysql and languages.

    Point being, performance wise, what could I encounter using 2 sites (2 different domains) under my shared hosting of 5gb bandwidth a month and a shared mysql database?

    Thanks
    Bryan

  2. #2
    SitePoint Guru marcel's Avatar
    Join Date
    Nov 2000
    Posts
    920
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    That should not be a problem.

    Just make sure you don't overquery the database. If you do you might have to increase the max number of connections to the database.

  3. #3
    SitePoint Wizard jag5311's Avatar
    Join Date
    Jan 2003
    Location
    Somewhere in Indiana
    Posts
    3,082
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    just for curiosity sake, would I see a "drop" in performance by using something like Coldfusion vs PHP with a mysql database?

  4. #4
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,347
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    would you see a drop in performance using a mysql database?

    probably not

    and it sure beats hardcoding the content

    or were you asking, is there a difference in performance between coldfusion and php?

    the answer is no, there isn't

    if there were, everybody would stop using the slower one
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  5. #5
    SitePoint Wizard jag5311's Avatar
    Join Date
    Jan 2003
    Location
    Somewhere in Indiana
    Posts
    3,082
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I think you hit the nail on the head Rudy.

    I always see these books about PHP and MYSQL and how they work hand and hand, so I didn't know. Another reason I asked is because currently I am simply using coldfusion for the include files with Movable Type, so considering the possibility of using PHP for that did cross my mind if there was going to be a difference, but according to you, there would not be.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •