MySQL 4.1.19 running on shared hosting service (I don't have access to upgrade)
I am doing a simple dedupe query on a table with ~8000 records. Should be very simple. I try a simple query before I do the delete (to double check), and it takes hours before I kill. Very simple:
Code:
SELECT *
FROM MyTable
LEFT OUTER JOIN (SELECT MIN(ID) AS ID FROM MyTable GROUP BY Name) AS GoodIDs ON (MyTable.ID = GoodIDs.ID)
WHERE GoodIDs.ID IS NULL;
I can do EXPLAIN and SHOW STATUS but I don't know what to look for. Any ideas are greatly appreciated.
Thanks!
dBforums
>
MySQL Dedupe Performance
07-13-06, 02:16
Linear Mode
