Will Tomlinson wrote: > What does everyone think about this? I used MySQL until I started using SP's. > Then I HAD to go with SQL Server for my needs. What will this mean for the db > market?
In my department at Duke, we have databases in MySQL 4.1 and Oracle 9. I've found Oracle to be exceptionally difficult to maintain, since I'm not a DBA. MySQL is much easier. However, we've done some performance testing, pitting Oracle against MySQL and SQL Server... and we found that SQL Server - on a smaller machine - actually performed faster than both MySQL and Oracle. MySQL was good when small amounts of data were returned versus Oracle, but SQL Server was faster pretty much across the board. SQL Server is also easier to maintain. I like MySQL, and I will continue to use it for pretty much all of my freelance web development, unless my clients desire otherwise. But in our department at Duke, where we're dealing with very large datasets (millions of rows in several tables), we're going with SQL Server (ie, we're going to phase out Oracle *AND MySQL and switch to SQL Server, even though Oracle is free for us, and SQL Server is not.) - Rick -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 2/14/2005 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195332 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
