MySQL Forums
Forum List  »  Performance

Re: slow update-join query
Posted by: Neha Kansal
Date: June 07, 2022 03:26PM

Sorry for the confusion. I actually updated my query with the correct column names so that everything else makes sense. I left the column names as is for the columns that are being used in the query. Pasting the actual query again.

update table1 a, table2 t set a.current_version = 1 where a.source_article_id = t.source_article_id and a.version = t.max_version;

Can you please reanalyze my previous reply with this query in mind. And also, please see the note about ranged queries I tried. I didnt change anything in the table schema before I ran those, Any insights into why the 10 mil ranged query was fast enough but the entire query wasn't - will be helpful. Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
463
June 07, 2022 12:55PM
190
June 07, 2022 01:00PM
214
June 07, 2022 01:19PM
224
June 07, 2022 02:27PM
206
June 07, 2022 02:55PM
Re: slow update-join query
207
June 07, 2022 03:26PM
208
June 07, 2022 05:06PM
186
June 07, 2022 06:20PM
219
June 08, 2022 09:51AM


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.