[cfaussie] Re: SQL Server vs MySQL

[Simon Haddon]

Hi,

The postgres option is a great one.  One of our tables is currently holding 140 million rows and we get sub second response from it.

I have been told that mySQL 5 is really good.  It is also suppoed t be the speed champion.

Cheers,
Simon Haddon

On 13/11/06, Toby Tremayne <[EMAIL PROTECTED]> wrote:

I'd second that - I've been using postgresql for years, and it's a fantastic product.  There are plenty of people you can get support from in australia, including some of the core dev team, and pgsql can run as fast or faster than mysql when properly setup.  

Toby

On 13/11/2006, at 12:23 , [EMAIL PROTECTED] wrote:

On Sun, Nov 12, 2006 at 05:04:40PM -0800, Matthew wrote:

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?

Instead of looking at moving to MS SQL anything, check out PostgreSQL.

http://www.postgresql.org/

It's open source and much better than MySQL at handling heavy transactional

(ie: multiple concurrant read & write) sites. 

There's local support through Fujitsu if management gets fussy about

having someone to have on call.

The latest versions (8.1, soon to be 8.2) have Point In Time Recovery

(PITR) facilities that let you backup the entire server in a very

short period of time. A couple of commands and an RSync session are

all that's needed. 8.2 will introduce additional commands designed

to make a hot-spare system much easier to setup, as well.

Cheers

Paul Haddon

Technical Services Manager

Formstar Print Technologies

--
Cheers
Simon Haddon
--~--~---------~--~----~------------~-------~--~----~
 You received this message because you are subscribed to the Google Groups "cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en
-~----------~----~----~----~------~----~------~--~---