SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Enthusiast didimo's Avatar
    Join Date
    Jan 2006
    Posts
    79
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    mysql or mysqli. whats better?

    background
    -----------

    i have a large web application, with over 20000 users (about 100 people using at any time)

    now im making a new version in PHP 5.1 (on FC3 linux, apache2, mysql 5 server)
    of the web app

    i use PEARB (and other pear libraries alongside my php5 classes) for database connection


    question
    --------
    the app works fine with MYSQL and MYSQLI

    which should i use? which is faster?

    for me performance is the target thats why im recoding the system into php5
    im also using alot of object caching to reduce database load

    oh and almost forgot;
    current database size is 800mb
    im reduced that to 100mb by changing schema and using caching

  2. #2
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    i've never tested them for speed. with pear::db, it very easy to change. so why don't you set it for one, then change it the next week to the other?

  3. #3
    SitePoint Enthusiast didimo's Avatar
    Join Date
    Jan 2006
    Posts
    79
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    thats what i was going to do, im just wondering if anyone has any facts or experience regading speed comparison (if they exist)

  4. #4
    SitePoint Evangelist DMacedo's Avatar
    Join Date
    May 2004
    Location
    Braga, Portugal
    Posts
    596
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Cool

    Making it simple, MySQL is old, while MySQLi is new, so that should already point to you towards which should be best

    But talking really, if you don't need the advanced features of MySQLi, I would stick to MySQL due to portability between older versions of PHP. I can imabine there could be true significant improvements in MySQLi.

    My view is that MySQLi is better, but still has to prove itself, and I can't benchmark everything just to prove my views.
    ~ Daniel Macedo


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
  •