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

Share :

Tweet

✚

Related Post

• Adding Text to a TextArea from a variable PHP<form method="POST"> <label for="Players"> Players Team One: </label> <?php
• Error While Connect MySQL DAtabaseHi guys i want to ask you about connect mysql database from different hosting servers using php. an
• Is there a way to extract all queries from this database?www . daccaa . org/meetings.htm They make it insanely difficult to find meetings, you have to know
• ElectroCRUD - Young MySQL CRUD AppNo coding is required; Create basic CRUD (Create, Read, Update, Delete) for your MySQL Database in
• Mysql newbie questionI have 3 tables TABLE #1 "users" 3 columns User-ID int (11) Location varchar (250) Age int (11) Pri
• MySQL CONCAT, HAVING and JOINhi can this be use all together? here is my query: SELECT CONCAT(fullname," ",address1," ",city,"