Rick That's an interesting post, in particular the fact that despite Oracle and MySQL being free (for your organization), you are moving to SQL server *because its easier to maintain*.
Kola > -----Original Message----- > From: Rick Root [mailto:[EMAIL PROTECTED] > Sent: 18 February 2005 03:18 > To: CF-Talk > Subject: Re: MySQL charging hard? > > 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:195368 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