MySQL Forums
Forum List  »  Performance

mySQL and slow performance - try MaxDB!
Posted by: Rob Drake
Date: March 07, 2005 03:13AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
mySQL and slow performance - try MaxDB!
2875
March 07, 2005 03:13AM


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.