2 messages in com.mysql.lists.win32MYSQL vs MSSQL
FromSent OnAttachments
Burkard Endres03 Jan 2001 04:56 
Sinisa Milivojevic04 Jan 2001 03:37 
Subject:MYSQL vs MSSQL
From:Burkard Endres (bEnd@i-te.com)
Date:01/03/2001 04:56:03 AM
List:com.mysql.lists.win32

Hi

while evaluating MySQL i have some Problems. If I run simple SQLStatements against MySQL, MySQL is realy fast (I am testing under Windows 2000). But if I use Join Queries MySQL slows extremly down. Example: if I select the same database in Mysql and MSSQL Mysql is about a third faster than MSSQL. But with join queries Mysql needs about four the time than MSSQL. Can someone tell me how to configure Mysql to speed up?

Kind regards

Burkard Endres

i-te systems GmbH Marcusstrasse 7 97070 Wuerzburg Germany http://www.i-te.com