#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2007
    Posts
    238
    Rep Power
    15

    Database bottleneck - MYSQL / Mongo / Other


    Hi,

    I am starting to create a website that is focused around getting data from a database. It is basically a community forum style site. I expect there to be a lot of traffic and concurrent users and I am almost certain that the database, if anything, will be the bottleneck.

    I was wondering if MongoDB would offer better performance than MySQL with a PHP coded site. It seems that MongoDB is faster, but is only worthwhile in certain situations. Would something like a forum be one of these situations?

    Regards,

    James
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,280
    Rep Power
    4279
    Originally Posted by spadez
    ... and I am almost certain that the database, if anything, will be the bottleneck.
    feh !!

    actually, your application language is the bottleneck

    how come you aren't asking for alternatives to using php?

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2007
    Posts
    238
    Rep Power
    15
    Im pretty happy with the performance I'm going to achieve with PHP.

    What I want to know is, my database is going to be pretty structured and logical. My impression is that the performance of Mongo comes from reading databases which are a bit more scattered and unstructured.

    Does this mean, in this instance, im better sticking to MySQL?

IMN logo majestic logo threadwatch logo seochat tools logo