MySQL Forums
Forum List  »  Newbie

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)

Options: ReplyQuote


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


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.