Jump to content

mattcass

New Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

mattcass's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. New to the group and I can't find any posts on [b]when it would be good design to use multiple databases[/b]. I am building a website that will allow access for 3 different types of users:  owners, admins, and users.  Each of these user types will have their own unique tables and fields.  I expect there to be over 10,000 users for each type. Now, I realize that I can just use one database and create a bunch of tables in it, each specific for my 3 user types.  And this would be easier for me to program. Conceptually, however, it seems to make better sense to use a different database for each user type. I would like to know if it is better/faster/more resource efficient/etc to use one large database with many tables, or to break it down into 3 databases, one for each user type. Thanks for reading this and your input! Matt
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.