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.
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.
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
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
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.
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
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...
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
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!
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.