Simple JOIN is extremely slow.
I am trying to do a simple UPDATE with a join and it takes about 23 minutes on a 2.66GHz (Ubuntu VirtualBox guest on Mac OS host) machine with plenty of ram. My CPU is otherwise free. Here's the query:
UPDATE reservations r
JOIN contacts c
ON r.CLIENT = c.breeze_id
SET
r.contact_id = c.id
WHERE r.contact_id IS NULL;
'reservations' has 7000 entries and 'contacts' has 146,000 entries, and the values in the ON clause are varchar(255).
Is there some weird mysql thing that I'm missing here? It seems like it should be much, much faster than that.
Subject
Views
Written By
Posted
Simple JOIN is extremely slow.
3065
June 10, 2011 10:34AM
1013
June 12, 2011 11:50AM
913
June 12, 2011 03:24PM
920
June 13, 2011 12:25PM
1893
June 13, 2011 12:07AM
1100
June 13, 2011 11:01AM
951
June 14, 2011 06:49AM
1006
June 14, 2011 08:04PM
1144
June 15, 2011 01:16AM
1004
June 15, 2011 07:38PM
937
June 15, 2011 11:42PM
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.