Developer Forum

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

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

> 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/

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.

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
==================

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

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

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

> >> 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/

Exactly!


Depends on how you look at it...

i

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

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/

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
==================

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/

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
==================