filling dataset - speed

[brain2cpu]

I'm shocked: the line dataAdapter.Fill(dataSet, dataTableName); (a local MySQL :mad: connection, ODBC, 8k rows) took more than 1 min to execute, it needs about 2 min to show the window just I'm so unlucky ? or it is a known performance problem here? can I do something to speed it up? (I HAVE to show all those lines) Thanks

[WillemM]

I know the problem, mysql and odbc have a speed penalty in the managed code... try to use microsoft desktop database engine instead of the mysql database. This one is fully supported and costs nothing :) Greetings.... :)