Hi, I've been working on a website built using MySQL and have been frustraited by it on numerious occasions over the past 8 months. Admittedly we are running v4.1 however because I've got much more experience with SQL Server (and from what I've read it is the better choice) I'm looking for some feedback on MySQL 5 vs SQL Server 2005?
Some of my frustrations with MySQL are: - Only 1 query per <cfquery> - Unable to handle complex join queries e.g. I ran a complex query in a trail version of SQL Server 2000 and it returned in 3 seconds, it took 33 mins in MySQL (this may be becuase we are using a non enterprise version - are there different versions???) - The server grinds to a holt with my complex queries which in turn kills the website. The same thing happens when I try to export a backup of the entire DB. I obviously have to justify the cost of SQL Server however would anyone argue the MySQL 5 enterprise would be better? By the way, I can't really understand the pricing structures of both products. We are only using the DB for the website, so does that mean we only need 1 liecence? If so does that mean I'm correct in saying that MySQL basic would be $595/year, where as SQL Server 2005 (5-Client) would be $1550 outright? Why does MySQL having an ongoing cost? Also, can anyone recommend MySQL Silver? Is the enterprise dashboard really worth it? Cheers Matthew ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260133 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
