I am working on a new web app that allow users to "save" pictures they like. I have a big table with many pictures and another table with users information. My question: How can I save the pictures each users "save"? I mean what is the proper way to save that information. I thought of making a new table with the user id and the picture id but I think maybe it is too messy and in the future it will take to long to make a query.
Thanks you very much
分享 you can do either things you can either make tables the way you mentioned or you can create different tables for different users {which makes it easier for you to display images saved by each user}
you can use certain nomenclature for tables like <user_id>_savedimages
for example you can have a table 21_savedimages for a user with id 21 this makes the task faster and less messy but this in turn results in lots of table in database.
you can decide yourself depending upon no of users you have and average no of images a user is saving.
分享
