Database design question

I have an app with the posibility for users to login( I created a table users, set the columns and it is working good). The problem is that every user can add other users to a favorite list. What would be the best way to store the favorite_users list for all users. I know that I could set a table like( id_parent_user, id_favorite_user ) but if there are 500 000 users and each has 50 there would be 25 000 000 rows. Is there a faster storage design than this ?

from Databases http://ift.tt/1Jvpfo2
via IFTTT
Previous
Next Post »
Thanks for your comment