Re: Foreman query optimization
Is there a big performance diff between Select...Left Join... and Delete...Left Join...? If so, did you try dropping all indexes except the one you need?
If optimisation fails, you may need to look at chunking, eg see
http://mysql.rjweb.org/doc.php/deletebig
Subject
Views
Written By
Posted
1970
November 05, 2015 04:15PM
844
November 05, 2015 05:42PM
866
November 05, 2015 06:54PM
798
November 05, 2015 11:19PM
891
November 06, 2015 11:58AM
Re: Foreman query optimization
810
November 06, 2015 12:35PM
785
November 06, 2015 06:44PM
877
November 26, 2015 08:56PM
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.