Reputation: 392
I need to make a library of products (this can be large), should I make a table per-user (lib_$user_id$
) or a common one (libs
)? Which is better in term of versatility and performance? Thanks.
Upvotes: 0
Views: 47
Reputation: 23816
Different table for each user is not good idea it would increase table as per user.
Use unique table for libs
where UserId will be Forigen key
Upvotes: 1