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?
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?