Gayner Posted October 9, 2009 Share Posted October 9, 2009 $DB->query("SELECT c.contact_name, c.contact_id, m.desktop, m.monkavatar FROM ibf_contacts c, ibf_members m WHERE member_id='".$member['id']."' AND c.contact_name=m.name ORDER By $rank LIMIT {$info['limitfriend']}"); am I calling all rows from the table "ibf_members" or just the specific ones? Cause i have alot of rows and Is there a more better performance way? Link to comment https://forums.phpfreaks.com/topic/177133-queiry-help/ Share on other sites More sharing options...
Daniel0 Posted October 9, 2009 Share Posted October 9, 2009 No, you're not. You're both limiting the results using WHERE and LIMIT. I'm not sure I entirely understand your question though. Link to comment https://forums.phpfreaks.com/topic/177133-queiry-help/#findComment-933967 Share on other sites More sharing options...
Gayner Posted October 9, 2009 Author Share Posted October 9, 2009 Like is that still calling all my rows in my table? or only the specific one's i chosen that have a c. before. ? Link to comment https://forums.phpfreaks.com/topic/177133-queiry-help/#findComment-933975 Share on other sites More sharing options...
Daniel0 Posted October 9, 2009 Share Posted October 9, 2009 That depends on if you have indexes on the fields you are selecting by. Link to comment https://forums.phpfreaks.com/topic/177133-queiry-help/#findComment-933986 Share on other sites More sharing options...
Gayner Posted October 10, 2009 Author Share Posted October 10, 2009 That depends on if you have indexes on the fields you are selecting by. U killed me right there Link to comment https://forums.phpfreaks.com/topic/177133-queiry-help/#findComment-934138 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.