query optimization
- by Gaurav
I have a query of the form
SELECT uid1,uid2 FROM friend WHERE uid1 IN (SELECT uid2 FROM friend WHERE uid1='.$user_id.') and uid2 IN (SELECT uid2 FROM friend WHERE uid1='.$user_id.')
The problem now is that the nested query
SELECT uid2 FROM friend WHERE uid1='.$user_id.'
returns a very large number of ids(approx. 5000).
The table…