MySQL Forums
Forum List  »  MySQL Workbench

Fetch very slow on local instance
Posted by: Terry McGregor
Date: March 15, 2017 07:20AM

Hi all,

First time poster and I'm hoping someone can help me. I am using the latest Version 6.3.9 (GPL) of the MySQL Workbench. I have an InnoDB database running as a Local Instance.

My issue is that the "Fetch" time of the first query below is 1.2sec (HUGE!!) and it only return 29K rows. I have also included a second query (as a benchmark) which returns a lot more rows ($500K) and yet the fetch time is lower at 0.6secs. Any ideas why this is happening??

Online help says "Fetch" time issues are almost always related to network issues. But I a running a local instance database, so there is no network.

SELECT departure_time
from stop_times, trips, terminal_stops
WHERE stop_times.trip_id = trips.trip_id
AND stop_times.stop_id = terminal_stops.stop_id
LIMIT 100000;
-- Duration=0.07sec / Fetch=1.2sec, 29K rows returned

SELECT departure_time
from stop_times
LIMIT 1000000;
-- Duration=0.00sec / Fetch=0.625sec, 500K rows returns

Any ideas are welcome.


Options: ReplyQuote

Written By
Fetch very slow on local instance
March 15, 2017 07:20AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.