mySQL query taking too long to return

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

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?
http://dev.mysql.com/doc/refman/5.0/...imization.html
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.

In article <1146690885.822618.141600@v46g2000cwv.googlegroups .com>,
"PJ on Development" <pjondevelopment@gmail.com> wrote:

> 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

Have you put an index on both epoch and pingRepply fields? Otherwise,
MySQL has to search the table linearly to return a result. If you are
just searching for the first record, try chopping the result up into
pages of 100 entries each with a LIMIT

--
DeeDee, don't press that button! DeeDee! NO! Dee...