Creating tables-VBForums
Results 1 to 2 of 2

Thread: Creating tables

  1. #1

    Thread Starter
    New Member
    Join Date
    Jun 2011
    Location
    Philippines
    Posts
    3

    Creating tables

    Is it efficient for me to have 1 table per user account? rather than 1 table many user many columns.?

  2. #2
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    37,090

    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).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.