how speed up data retrieve from large table (need big help)
Posted by:
tbhaw tan
Date: June 22, 2005 01:20AM
Dear all,
I try to retrieve duplicate data from database but it take a lot of time to display and very slow.Even using index also same .Here is my sql statement :
$sqlselect2 = "SELECT DISTINCT p1.resume_id, p1.user_id, p1.email, p1.name, p1.gender, p1.house_tel, p1.office_tel, p1.hand_tel, p1.new_ic, p1.old_ic, p1.address1, p1.address2, p1.city, p1.dob FROM resume_personal p1 ,resume_personal p2 where p1.$searchString=p2.$searchString And p1.resume_id!=p2.resume_id Order by p1.$sort $order ";
$result2 = mysql_query($sqlselect2,$conn) or die(mysql_error());
Anyones got the better solution to retrieve duplicate data or to improve the speed?Thanks.