Xriuk
Xriuk

Reputation: 392

MySQL per-user table or common?

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

Answers (1)

Manwal
Manwal

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

Related Questions