MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: How to increase query execution time?
Posted by: Peter Brawley
Date: August 29, 2017 12:44PM

You can increase the Connector/ODBC timeout limit, see https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-configuration-connection-parameters.html, but a query like the one you show shouldn't take so long---it needs optimising, so run explain on the query and post the result here (inside BBCode code tags for human readability)

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
How to increase query execution time?
Robert Feldman
August 29, 2017 11:50AM
Re: How to increase query execution time?
Peter Brawley
August 29, 2017 12:44PM
Re: How to increase query execution time?
Robert Feldman
August 29, 2017 03:21PM
Re: How to increase query execution time?
Peter Brawley
August 29, 2017 06:36PM


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.