mySQL and slow performance - try MaxDB!

[Rob Drake]

I responded to a posting in this forum comparing SQL Server 2000 and mySQL using the same tables etc and found that mySQL took about 2 minutes to perform a query - a fairlly complex one - that took SQL Server about 1 second. I had initially used mySQL v5.+ and then tried the same query in mySQL v4+. Incidentally using the 'limit' clause is obviously much faster.

In any event it was not meant to be a benchmark test - I don't do benchmark tests! I just couldn't believe that the query itself could take so long.

This test was not meant to be a "downer" on mySQL - I offer training in mySQL because it's a really great product so let's get that clear - and , like i said, knowing the problem is simply used the 'limit' clause (trainers find their way around things!).

SO ANYWAY :) I tried MAXDB (7.6) and found that the speed was about 1 second.

I hope that helps
Rob