Food for thought: From: http://www.mssqlcity.com/Articles/Compare/sql_server_vs_mysql.htm
"Conclusion It is not true that SQL Server 2000 is better than MySQL version 4.1 or vice versa. Both products can be used to build stable and efficient system and the stability and effectiveness of your applications and databases depend rather from the experience of the database developers and database administrator than from the database's provider. But SQL Server 2000 has some advantages in comparison with MySQL version 4.1 and vice versa. The SQL Server 2000 advantages: SQL Server 2000 holds the top TPC-C performance and price/performance results. SQL Server 2000 is generally accepted as easier to install, use and manage. Transact-SQL is more powerful language than MySQL dialect. The MySQL version 4.1 advantages: MySQL version 4.1 supports all known platforms, not only the Windows-based platforms. MySQL version 4.1 requires less hardware resources. You can use MySQL version 4.1 without any payment under the terms of the GNU General Public License. This is from MySQL version 4.1 documentation: MySQL Server was designed from the start to work with medium size databases (10-100 million rows, or about 100 MB per table) on small computer systems." http://builder.com.com/5100-6388-1054385.html http://tonybain.com/blog/posts/174.aspx The next version of SQL server will have the CLR available to stored procedures. That will open up huge possibilites IMO. Kind regards, Tom Nunamaker -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Colin Wilson Sent: Saturday, October 30, 2004 12:06 AM To: [EMAIL PROTECTED] Subject: RE: Data sources In this case - the first two options are access or sql 2000... The mysql is a possible but most likely we'd go for sql... Just trying to get a bit more info to use in convincing the company that the development time to convert to sql is necessary. Colin -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jacob Cameron Sent: October 29, 2004 3:01 PM To: [EMAIL PROTECTED] Subject: RE: Data sources The person said 'read only data', so not having backups is OK and mySQL runs much faster for that type of system. Heck, I'd use mySQL and cache the heck out of your webserver. The database choice doesn't really matter as long as you are just reading data. Jacob -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Nunamaker Sent: Friday, October 29, 2004 4:51 PM To: [EMAIL PROTECTED] Subject: RE: Data sources I know mySQL is improving, but the last time I looked at it, it didn't have many features that a robust DB server has: Stored procedures, views, UDF's, etc. What's the reasoning someone wants to use mySQL? Tom Nunamaker -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Colin Wilson Sent: Friday, October 29, 2004 11:29 PM To: [EMAIL PROTECTED] Subject: Data sources Does anyone have specifics about the best database to use for cold fusion.. Currently our site uses access as the database but I could set up SQL2000 - one of the guys at the company would rather use mysql... So of these - for fast response with lots of requests per minute.... Basically in a read only situation... Which database would be our best. All three are available options. Colin ---------------------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm ---------------------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm ---------------------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm ---------------------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm ---------------------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
