MySQL Forums :: MySQL Workbench :: Fetch very slow on local instance


Advanced Search

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.

Thanks.

Options: ReplyQuote


Subject Views Written By Posted
Fetch very slow on local instance 77 Terry McGregor 03/15/2017 07:20AM
Re: Fetch very slow on local instance 51 Terry McGregor 03/15/2017 08:19AM
Re: Fetch very slow on local instance 34 Jon Stephens 03/15/2017 12:40PM


Sorry, only registered users may post in this forum.

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.