Myslq slower than SqlServer

[juanmanuel]

Hello,
I've converted a SQL Server DB 7.0 into text files
like 'create table...' and 'insert into...'(like Mysql) to
test it with MysQL.

I have XP and myodbc installed on my PC.
I've been used innodb tables to ensure transacctions that works fine.

One table have 1742 rows and 84 columns. Only one integer primary key and very varchar() and char().

When I send a "select * from mytable;" it takes very very much from Mysql via myodbc and it's very quickly from SQLserver via ODBC.

If I send "select column1, column2 from mytable" it's a bit faster.

 

[sleipnir214]

And? Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[juanmanuel]

Hi,
Well, I notice It takes 10 s in SQLserver and more than
1 mn. in MySQL.
Does is it right that time?
Or my system don't work correctly.

Does anyone have test it with too many columns?


Thanks in advance.