MySQL Forums
Forum List  »  Stored Procedures

Re: Query times out when I add extra Where Condition
Posted by: Peter Brawley
Date: January 23, 2020 12:08PM

All those left joins will slow it down. How many can be converted to inner joins?

You probably need covering indexes. After you get rid of left joins to the extent possible, let's see Show Create table results for each table, the Explain result for the query inside BBCode code tags, MySQL version, innodb_buffer_pool_size, and amt of RAM available.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Query times out when I add extra Where Condition
133
January 23, 2020 12:08PM


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.