MySQL Forums
Forum List  »  Performance

30+ Million Member Default Images
Posted by: Justin
Date: September 06, 2005 01:20AM

I am worried about 30+ million member default images with friends list. When members table has 30+ million member default images then it will make query time slower because friends list will search for member default images in 30+ million member default images table long and use processor usage alot.

Members Table has default images

Friend Network Table has friends list.

SELECT FRIEND_FRIEND_ID, NICKNAME, IMAGE_DEFAULT FROM FRIEND_NETWORK, MEMBERS WHERE FRIEND_NETWORK.FRIEND_MEMBER_ID = '$PROFILE_MEMBER_ID' AND MEMBERS.MEMBER_ID = FRIEND_FRIEND_ID LIMIT 0,8

Options: ReplyQuote


Subject
Views
Written By
Posted
30+ Million Member Default Images
1987
September 06, 2005 01:20AM
1311
September 06, 2005 09:13AM
1305
September 06, 2005 08:59PM
1130
September 09, 2005 12:57AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.