On Wed, 11 Oct 2006 08:38:39 +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
>
> So you're not using transactions then?

Exactly!

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

Depends on how you look at it...

i

>> > 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.
>
> All sounds very thorough.
>
>