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

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

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


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