fast DEL when using LIKE mysql

admin

Administrator
Staff member
i have a database of about 80 million items.. and some times i have to do a remove using "LIKE" eg

delete from others where (name like "%.1bigred.com");

and it takes forever! like over 5min.. i have about 1700 words to run thru, the system is a 1Gz with 512MB ram, running only apache and Mysql, how can i speed this up?
 
Back
Top