Our test of MySQL vs. MS SQL Server

Our test of MySQL vs. MS SQL Server

Post by Ignoramus7 » Sun, 08 Oct 2006 01:17:27


Someone here tested MS SQL Server vs. MySQL. Both stock install
versions, no tweaking.

The result of tests, roughly, is that MySQL is about 2-3x faster than
MS SQL Server, when doing selects or inserts or updates.

So, we'll be going with MySQL. It is also to not pay money to anyone,
and to get a full version and not some bastardized "evaluation"
server.

i
 
 
 

Our test of MySQL vs. MS SQL Server

Post by Jack Vamva » Sun, 08 Oct 2006 01:27:01

Out of interest , what amount of data did you use? also, how did you measure
the speed on the mySQL?
I'm interested in this process, as I'm just about to start evaluating .


----
Jack Vamvas

 
 
 

Our test of MySQL vs. MS SQL Server

Post by Martijn To » Sun, 08 Oct 2006 02:20:54

> Someone here tested MS SQL Server vs. MySQL. Both stock install

Brilliant. What table type?

What version of MySQL?

What version of MS SQL Server?

How much data?

What kind of indices, if at all, did you use?

How many concurrent inserts did you try?

How many concurrent selects did you try?

In short: what kind of test did you actually run in order to make
such a statement?



--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.yqcomputer.com/
My thoughts:
http://www.yqcomputer.com/
Database development questions? Check the forum!
http://www.yqcomputer.com/
 
 
 

Our test of MySQL vs. MS SQL Server

Post by Martijn Li » Mon, 09 Oct 2006 04:02:30


Version 4 or 5 of MySQL? You are sure you don't need transactions?

I've seen way to many programmers not thinking about database concurrency
resulting in corrupted databases. If MySQL cuts it (it does for most of my
applications), fine. However, if you need a true database, the tables turn
(pun intended).

HTH,
M4
--
Redundancy is a great way to introduce more single points of failure.
 
 
 

Our test of MySQL vs. MS SQL Server

Post by Jerry Stuc » Mon, 09 Oct 2006 05:52:02


MySQL can do transactions just fine if you use innodb tables. No
problem at all.

Of course MSSQL has other features, but MySQL is rapidly catching up.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
XXXX@XXXXX.COM
==================
 
 
 

Our test of MySQL vs. MS SQL Server

Post by Ignoramus2 » Wed, 11 Oct 2006 00:28:37


a few tens/hundreds of thousands of records, a few thousands of
selects with all diferent keys, that's all I know. I am aware that
people can argue forever about what constitutes the most refined test,
and that perhaps ours was not that.

i
 
 
 

Our test of MySQL vs. MS SQL Server

Post by Ignoramus2 » Wed, 11 Oct 2006 00:38:01


MyISAM


MySQL 5


MS SQL Express '05, if I have that right.


About 100k records in various tables (about wehat we need)


Whatever was appropriate for the selects




no idea, we do not do concurrent statements in practice.


A bunch of selects and inserts, similar to what we need.

i
 
 
 

Our test of MySQL vs. MS SQL Server

Post by Ignoramus2 » Wed, 11 Oct 2006 00:39:01


5.


Well, though we do not do any concurrent statements due to our system
design, I thought tat MySQL 5 covers concurrency just fine, no?

i
 
 
 

Our test of MySQL vs. MS SQL Server

Post by Martijn To » Thu, 12 Oct 2006 15:38:39

> >> Someone here tested MS SQL Server vs. MySQL. Both stock install

So you're not using transactions then?

I hope it's not a so-called mission-critical application.


All sounds very thorough.


--
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.yqcomputer.com/
My thoughts:
http://www.yqcomputer.com/
Database development questions? Check the forum!
http://www.yqcomputer.com/
 
 
 

Our test of MySQL vs. MS SQL Server

Post by Ignoramus3 » Thu, 12 Oct 2006 22:28:26


Exactly!


Depends on how you look at it...

i
 
 
 

Our test of MySQL vs. MS SQL Server

Post by Peter H. C » Thu, 12 Oct 2006 22:39:44


Not all mission-critical applications require transactions. Some
criticality is for lookups against essentially static data, for example,
that can be updated during maintenance windows.

--
17. When I employ people as advisors, I will occasionally listen to their
advice.
--Peter Anspach's list of things to do as an Evil Overlord
 
 
 

Our test of MySQL vs. MS SQL Server

Post by Martijn To » Fri, 13 Oct 2006 01:03:15


Right, applications that only "read" data, wouldn't need transactions.
That is, if the data isn't being updated at the same time.

However, any data update requires transactions. Period.


--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.yqcomputer.com/
My thoughts:
http://www.yqcomputer.com/
Database development questions? Check the forum!
http://www.yqcomputer.com/
 
 
 

Our test of MySQL vs. MS SQL Server

Post by Jerry Stuc » Fri, 13 Oct 2006 04:58:24


Incorrect. A single insert or update to a table does not require a
transaction.

Multiple updates, inserts/updates to multiple tables and
read/wait/update almost always require transactions for safety, though.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
XXXX@XXXXX.COM
==================
 
 
 

Our test of MySQL vs. MS SQL Server

Post by Martijn To » Fri, 13 Oct 2006 15:17:16


I figured someone would say that.




I'll take transactions and - perhaps - a slight performance decrease
every day above no transactions.


--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.yqcomputer.com/
My thoughts:
http://www.yqcomputer.com/
Database development questions? Check the forum!
http://www.yqcomputer.com/
 
 
 

Our test of MySQL vs. MS SQL Server

Post by Jerry Stuc » Fri, 13 Oct 2006 22:15:38


I'd rather use transactions when necessary, and not use them when they
are not required.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
XXXX@XXXXX.COM
==================