MySQL Forums
Forum List  »  Performance

Benchmark mySQL 5 and SQL Server 2000 - horrific!
Posted by: Rob Drake
Date: February 18, 2005 12:37AM

I've experieced the same problem - here's a benchmark test.

Here's the query:

select learnercode,language,lastname,left(firstname,1) as 'in',gradecode as grade,
disciplinesnamelang2 as 'Detail'
from learners as a
inner join disciplinesaudit as b
on learnercode=auditlearnercode
inner join disciplines as c on b.disciplinescode=c.disciplinescode order by gradecode,learnercode;

The query returns 1817 rows:

In mySQL it takes 2 minutes 40 seconds - (say two minutes forty seconds)
In SQL Server 2000 it takes 1 second.- (say one second)

And, yes, it's the same PC, same tables in the database.

In fact the PC utilisation goes to 100% and pretty much stays there for long enough for me to think that the PC is hanging. The mySQL admin shows just about 0% utilisation.

Options: ReplyQuote

Written By
February 15, 2005 03:39PM
Benchmark mySQL 5 and SQL Server 2000 - horrific!
February 18, 2005 12:37AM
March 14, 2005 06:13AM
February 18, 2005 03:17PM
February 21, 2005 01:41AM
February 23, 2005 05:29PM
February 23, 2005 06:39PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.