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
1006
January 23, 2020 04:42AM
Re: Query times out when I add extra Where Condition
450
January 23, 2020 12:08PM
439
January 24, 2020 05:25AM
434
January 24, 2020 05:53AM
454
January 24, 2020 02:14PM
415
January 27, 2020 04:28AM
494
January 27, 2020 12:59PM
445
January 28, 2020 05:30AM
423
January 28, 2020 08:52AM
476
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.