Re: Query times out when I add extra Where Condition
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.
Subject
Views
Written By
Posted
871
January 23, 2020 04:42AM
Re: Query times out when I add extra Where Condition
371
January 23, 2020 12:08PM
359
January 24, 2020 05:25AM
344
January 24, 2020 05:53AM
373
January 24, 2020 02:14PM
343
January 27, 2020 04:28AM
390
January 27, 2020 12:59PM
353
January 28, 2020 05:30AM
341
January 28, 2020 08:52AM
379
January 29, 2020 05:10AM
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.