Ignoramus8392 <ignoramus8392NOSPAM.8392.invalid> wrote:
You should be embarrassed! It's been proven in multiple benchmarks on> This is NOT a troll post, and I am long time MySQL user. I suspect that I
> made some up with configuration. MySQL is a lot slower than MS SQL
> server, both running on Windows XP.
> I have a specific task that occurs based on an event and involves
> about 45 queries. INSERTs, UPDATES, a couple SELECTS. Nothing special.
> I keep track of how long each query takes, using a low resolution
> system timer (0.014 sec resolution).
> The queries take about 1.6 second in MySQL and almost no time at all
> with MS SQL server (about 0.07 seconds).
> Our tables are NOT large, and while some queries are big (a lot of
> fields mentioned in UPDATE), they are nothing out of the ordinary,
> just a few dozen fields.
> I am completely stumped and even EMBARRASSED, as I was the person who
> promoted MySQL.
> Any ideas?
> I will provide any requested information.
different platforms that MySQL performs much faster than SQLServer all other
factors being equal.
Send your my.cnf or my.ini file or actually post it right here! I bet there
is a bunch of stuff that can be done to it to make it run faster.