Locked Posted November 22, 2007 Share Posted November 22, 2007 Would the query bellow be better than: mysql_query("select name from table where userid=1"); or mysql_query("select name from table where userid=1" and password='password' and username='me'); Question: Does the more detail you give in the where statement better/faster? (Names/passwords etc would be stored in sessions when they login) Link to comment https://forums.phpfreaks.com/topic/78445-solved-querywhere-performance-question/ Share on other sites More sharing options...
wsantos Posted November 22, 2007 Share Posted November 22, 2007 If those fields are indexed then yes...otherwise no. Link to comment https://forums.phpfreaks.com/topic/78445-solved-querywhere-performance-question/#findComment-397033 Share on other sites More sharing options...
Locked Posted November 23, 2007 Author Share Posted November 23, 2007 Thanks and yes they are index's Link to comment https://forums.phpfreaks.com/topic/78445-solved-querywhere-performance-question/#findComment-397164 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.