faster database

Discussion in 'Programming' started by belablack, Dec 11, 2005.

  1. #1
    hi,

    a Q for you experienced cfm'ers -

    I'm currently using an Access Database, would it benefit me to move to a MySQL database ?

    Curious.
     
    belablack, Dec 11, 2005 IP
  2. tbarr60

    tbarr60 Notable Member

    Messages:
    3,455
    Likes Received:
    125
    Best Answers:
    0
    Trophy Points:
    210
    #2
    Access is intended to be a desktop database, MySQL is a server based database. Access will work for a website but it is not recommended, move to MySQL as soon as you are ready.
     
    tbarr60, Dec 14, 2005 IP
  3. J.P

    J.P Notable Member

    Messages:
    767
    Likes Received:
    42
    Best Answers:
    3
    Trophy Points:
    205
    #3
    I used to use a access DB with CF for a couple of sites, worked fine when I had a few row's in the tables.

    The site got a bit more traffic and the whole thing started to come to a halt, switched over to MySQL and it's faster now than it ever has been, I would recomend switching as soon as.

    JP
     
    J.P, Dec 14, 2005 IP
  4. Nitin M

    Nitin M White/Gray/Black Hat

    Messages:
    640
    Likes Received:
    93
    Best Answers:
    0
    Trophy Points:
    0
    #4
    yeah, no question about it. if you need to support many users online accessing the db simultaneously then you need to make the switch to mySQL
     
    Nitin M, Dec 14, 2005 IP
  5. Mitch

    Mitch Guest

    Messages:
    21
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    MySQL would really help from the performace side. If you are coming from MSAccess and have never used MYSQL it may present a large learning curve for you.
     
    Mitch, Feb 24, 2006 IP
  6. Nakirema

    Nakirema Peon

    Messages:
    113
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #6
    I would definetly suggest moving to MySQL.. I just made the change myself and yes... It is very different. Once you get down the real database terminology and design structure, then it's not so bad.. It's a bit tricky setting up the datasource in coldfusion but they do have tutorials. As far as an interface for working with MySQL, I would stay away from CFMyAdmin.. I know, I know - we coldfusion programmer want to stick with coldfusion programs, but CFMyAdmin sucks.. Use PHPMyAdmin.. It's much better.
    Nakirema
     
    Nakirema, Mar 1, 2006 IP
  7. petarddd

    petarddd Peon

    Messages:
    132
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Changing the database will definitely be a plus (anything is better than Access for web sites :).

    If you've been running access so far, you are probably dealing with a Windows platform and are probably used to graphical interface... You may want to look at the MS SQL Express (the free version of MS SQL) - it may be perfect for your need and much easier to administer and set up than mySQL...
     
    petarddd, Mar 6, 2006 IP
  8. DMAC

    DMAC Peon

    Messages:
    7
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #8
    Last I heard Google used a modded version of MySQL because they wanted no frills and speed. So yeah I'd say MySQL is a good way to go for performance especially compared to MSAccess
     
    DMAC, Mar 22, 2006 IP
  9. belablack

    belablack Well-Known Member

    Messages:
    145
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    180
    #9
    but Myspace uses CFM haha but probably not access.. I alreayd use a lot of SQL so no biggie. I know its more efficient. Thanks!
     
    belablack, Apr 10, 2007 IP
  10. IsRoss()

    IsRoss() Peon

    Messages:
    116
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #10
    Myspace has migrated mostly to .NET, with some older CF code running on Blue Dragon servers.
     
    IsRoss(), Apr 11, 2007 IP
  11. kirby009

    kirby009 Peon

    Messages:
    608
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #11
    Access is a database which is like msql data base. same concept differentway of doing the same job. throwing access into mysql you would need to orginize you data in access then throw it into msql. onless there is some software out there.
     
    kirby009, Jun 29, 2007 IP