Is it efficient for me to have 1 table per user account? rather than 1 table many user many columns.?
Printable View
Is it efficient for me to have 1 table per user account? rather than 1 table many user many columns.?
Multiple copies of a table is not efficient. It makes coding and maintenance much harder, and is likely to increase the storage space needed.
For similar reasons (but to a lesser degree) multiple columns is not good either - what you should be aiming for is multiple rows (in this case one row per user account).