0

Mysql query takes forever

I want to delete rows with some duplicate feilds. I run this command but it takes too long. DELETE t1 FROM users t1 INNER JOIN users t2 on t1.user_email = t2.user_email; +Table is pretty big

4th Apr 2020, 5:46 PM
Parsa Gholipout
Parsa Gholipout - avatar
2 Antworten
+ 2
Optimizing queries is the first thing to do for more speed. Configuring your mysql server. Updating your hardware. Its no surprise a big database takes time with regular hardware
4th Apr 2020, 6:53 PM
Toni Isotalo
Toni Isotalo - avatar
+ 1
It's not my hardware. I'm running it on my personal computer which has ok specs I think
4th Apr 2020, 6:56 PM
Parsa Gholipout
Parsa Gholipout - avatar