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
819
January 23, 2020 04:42AM
Re: Query times out when I add extra Where Condition
343
January 23, 2020 12:08PM
337
January 24, 2020 05:25AM
315
January 24, 2020 05:53AM
345
January 24, 2020 02:14PM
320
January 27, 2020 04:28AM
351
January 27, 2020 12:59PM
332
January 28, 2020 05:30AM
311
January 28, 2020 08:52AM
344
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.