mySQL query taking too long to return

[PJ on Development]

Greetings,

I'm using mySQL in a VB.NET application, connecting it through the
myOLEDB Provider.

However, it's taking way too long to retrieve data from the server.

For instance I have a simple table with two fields: [epoch] and
[pingRepply] wich houses approx 720,000 records.

Retrieving the data using the MySQL Query Browser it feetch all the
rows in approx 5min.

When I run my application it retireves the same data it takes more than
half an hour.

Can someone point me to the right direction?mySQL query taking too long
to return

[Bill Karwin]

PJ on Development wrote:

> Retrieving the data using the MySQL Query Browser it feetch all the
> rows in approx 5min.

Why so long? Even 5 minutes for 720K rows is probably too long,
indicating that there are things you can do to improve this. What have
you done to analyze the query with EXPLAIN, improve the coverage of
indexes, tune the server for this application, etc.? Where's the
bottleneck?

Have you read the chapter of the MySQL manual on optimization?
[url]http://dev.mysql.com/doc/refman/5.0/en/optimization.html[/url]
You haven't given much information about the MySQL version, the
platform, server config, the tables, or your query. There are many tips
in that chapter that could potentially help a lot.

I don't have any experience with VB or myOLEDB, so I can't comment on
why the query is so much slower in your case. Levels of interface
abstraction frequently introduce some performance cost (though a sixfold
decrease in performance is unexpected).

You should first see if you can improve the performance relative to the
non-VB interface.

Regards,
Bill K.