MySQL Forums
Forum List  »  Newbie

Re: How to increase query execution time?
Posted by: Robert Feldman
Date: August 29, 2017 03:21PM

Thanks for the response.

First a question: Which ODBC connection code(s) should I adjust?

Second, here are the EXPLAIN results (in two subsets):
id..select_type..table..........................partitions..type..possible_keys
1...INSERT.........tbl_stops_for_routes..Null.........ALL....Null
1...SIMPLE.........tbl_gtfs_trips..............Null.........ALL....Null
1...SIMPLE.........tbl_gtfs_stop_times...Null.........ALL....Null


key....key_len..ref....rows..filtered......extra
Null..Null.........Null..Null..........Null......Null
Null..Null.........Null..15293......10.00....Using where; Using temporary
Null..Null.........Null..1125040..10.00....Using where; Using join buffer (Block Nested Loop)


As a workaround, I copied the two MySQL tables locally to MS Access and the same query runs in just a few seconds locally. The delay and timeout seem to come from the MySQL ODBC connector, although I admit that the tables are not indexed.

Options: ReplyQuote


Subject
Written By
Posted
Re: How to increase query execution time?
August 29, 2017 03:21PM


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.