RE: SQL Server 2005 vs MySQL 5?

2006-11-14 Thread Munson, Jacob
> > Some of my frustrations with MySQL are: > > - Only 1 query per > > I happen to think that is a good thing :) Sorry, I have to jump in here. I agree with this, it is a good thing. They don't allow multiple queries because to do so is a security risk. But I always laugh because whenever I bri

Re: SQL Server 2005 vs MySQL 5?

2006-11-13 Thread Adrian Moreno
> Some of my frustrations with MySQL are: > - Only 1 query per MySQL can handle multiple queries, it's just disabled by default. Cameron Childress has a post about this. MySQL: How to Combine Multiple SQL Statements in One CFQUERY http://www.sumoc.com/blog/index.cfm?mode=entry&entry=7F6F7314-50

Re: SQL Server 2005 vs MySQL 5?

2006-11-13 Thread Jochem van Dieten
Matthew Chambers wrote: > > Some of my frustrations with MySQL are: > - Only 1 query per I happen to think that is a good thing :) > - 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 M

RE: SQL Server 2005 vs MySQL 5?

2006-11-12 Thread Snake
To cut your cost for SQL Server find an SPLA partner and pay $10 month instead. Russ -Original Message- From: Matthew Chambers [mailto:[EMAIL PROTECTED] Sent: 12 November 2006 23:57 To: CF-Talk Subject: SQL Server 2005 vs MySQL 5? Hi, I've been working on a website built using

SQL Server 2005 vs MySQL 5?

2006-11-12 Thread Matthew Chambers
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