Feb 26th, 2012, 05:50 AM
Is it efficient for me to have 1 table per user account? rather than 1 table many user many columns.?
Feb 26th, 2012, 06:04 AM
Re: Creating tables
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).
Click Here to Expand Forum to Full Width
Survey posted by VBForums.