i have a mysql statement within my social networking site that shows a members friendslist. the problem is that when a member gathers anywhere near 1000 friends the entire site slows down trying to gather the right information. I hardly know anything about mysql but i have been reading http://www.experts-exchange.com/articles/Database/MySQL/3-Ways-to-Speed-Up-MySQL.html
so i now understand that this statement is not using all indexes and does a number of table scans for the code.
I have attcahed a file to this question that has the table in question viewing its structure, browsing it and the mysql statement i am refering to and the statement with "explain" results
If you need more details feel free to ask me for them