On Fri, 6 Oct 2006 19:20:54 +0200, Martijn Tonies <m.tonies@upscene.removethis.com> wrote:
>> 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.
>
> Brilliant. What table type?

MyISAM

> What version of MySQL?

MySQL 5

> What version of MS SQL Server?

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

> How much data?

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

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

Whatever was appropriate for the selects

> How many concurrent inserts did you try?


> How many concurrent selects did you try?

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

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

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

i

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