MySQL SLOW!!!

[Joshua Tirey]

I have a .NET application that currently uses Microsoft Access for its database. I have been looking into switch from Access to MySQL, because the database can get pretty large and Access is terrible once it gets very big.

I recently ran a test using part of my code that takes values in an ASCII text file and stores it into the database. First I ran the code that connects to the Access database and it took 35mins to read through the file and insert 5291 records into 1 table and 188785 records into another table. I then switched the connection objects that were being used over to the corresponding objects from the MySQL .NET Connector AB. To read through the exact same file, and insert the exact same number of records it took 2hrs and 9 mins.

Is MySQL just this slow, or is there some setting I need to change to speed it up? I have also seen a vew other .NET connectors available for MySQL, is the problem coming from the MySQL data provider? Any information anyone can offer would be greatly appreciated. If you need more information about my setup, just ask and I will respond as quickly as possible.