Does anyone know which is better performance wise? I have always thought MSSQL was generally better in terms of speed, scalability, and stability, until I found out that MySQL MaxDB supports a lot of new features including stored procedures/triggers + I saw
this graph(s): http://www.eweek.com/slideshow/0,3670,s=1590&a=23120&po=1&i=1,00.asp And since I'm on this topic of performance, what do you think is the best server (IIS, Apache)? I would appreciate your 2 cents.
If you're strapped for cash: mySQL (free) + Apache (free) If you've got money to burn: MSSQL + Apache Even though I know IIS like the back of my hand it's exploited the most so if it was my server I wouldn't use it. Also it costs a packet when there are free
webservers like Apache around that do a great job! This topic is a bit of a flame bait, but hey, this is my $0.02 Andrew
True, I actually use IIS and SQL2000 - though I'm told by my company to use this. If it was up to me I'd definately use mySQL and I'm guessing I'd have to investigate the free alternatives that support ASP.NET! Andrew
According to the link you did post, MS-SQL server is the fastest so ... easy to pick then isn't it ;). Note: since Image 1/2 seems to measure using CGI (where the limitation is IIS and not MS-SQL since it sucks at CGI very much ;)) and you are using ASP.Net
you have to compare to Image 4/5 where you will see that MS-.SQL Server wins in both tests, response times as well as pages served. Also if you are not planning for sites with 1000 concurrent users you can use also free MSDE which is a restricted version of
SQL-Server 2000 in terms of database size (max. 2GB), max supported CPUs (1) and open connections. See Microsoft MS-SQL Server site for exact details. Hth, Moon
Most of the information I've ever seen indicates that MySQL is natively much faster than MS SQL Server. Also thousands of $ cheaper. That seems pretty clear to me. These comparisons are *never* apples-to-apples, though. I read an article about a year ago, though,
in which an independent third-party found then-current versions of MySQL to be faster than then-current Oracle, Informix, and MS SQL Server. MySQL is feature-limited in some respects, so it depends what features you really need. Hey, I used to think I couldn't
live without foreign key constraints. But then I learned about my bad, bad habits... :-) MSDE, in my opinion, eventually forces the user down the road of upgrading to MS SQL Server. Your data gets held hostage in their format -- at least the first couple of
gigs. Of course. That's the whole point. Don't get me wrong -- I love M$ as much as anybody around here. I use their operating systems and applications and languages and development tools and... and... and even some of their hardware (which goes against the
following): But, use the right tool for the job, that's all I'm saying. Love Microsoft. I do. But don't get sucked into their expensive, bloated database engine. Since you're asking, I think you'll regret it. Best of luck, whatever you decide. Regards, - Don
And now that MySQL 5.0 is here (with stored procedures etc) MySQL is looking a better option imho, but I'm strapped for cash :) If I had millions of dollars I'd go SQL2000.
> MySQL is free and fast but easier to corrupt due to hardware or power faliures for example. I've seen this 1st hand and it wasn't pretty Due to hardware or power failures?! That's like saying "I thought my OS was uncrashable until I attacked my hdd with an
axe". If you're really worried, pick up a small UPS - or schedule backups more often.
halfline
Member
15 Points
3 Posts
MSSQL vs. MySQL
Dec 20, 2003 06:14 AM|LINK
Andrewphq
Contributor
7338 Points
1472 Posts
Re: MSSQL vs. MySQL
Dec 22, 2003 03:28 AM|LINK
Shannara
Member
425 Points
85 Posts
Re: MSSQL vs. MySQL
Dec 23, 2003 05:54 PM|LINK
Andrewphq
Contributor
7338 Points
1472 Posts
Re: MSSQL vs. MySQL
Jan 08, 2004 02:02 AM|LINK
Moon
Participant
830 Points
166 Posts
Re: MSSQL vs. MySQL
Jan 11, 2004 03:37 PM|LINK
DonYeske
Member
135 Points
27 Posts
Re: MSSQL vs. MySQL
Jan 26, 2004 10:37 PM|LINK
Andrewphq
Contributor
7338 Points
1472 Posts
Re: MSSQL vs. MySQL
Jan 27, 2004 02:52 AM|LINK
melvincureto...
Member
189 Points
40 Posts
Re: MSSQL vs. MySQL
Feb 10, 2004 01:18 PM|LINK
The Head Gee...
Member
5 Points
1 Post
Re: MSSQL vs. MySQL
Feb 15, 2004 11:56 AM|LINK
Andrewphq
Contributor
7338 Points
1472 Posts
Re: MSSQL vs. MySQL
Feb 20, 2004 03:33 AM|LINK