Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2006
    Posts
    3

    Exclamation Unanswered: Benifit for Seperate Database?

    Hello,
    i'm planning to design a database stucture. i'm planning to use two seperate database to keep my data for web development. Is it wise to keep data in seperate database?

    I'm doing this because, each time when a user register with us in the web site, a Second Table will be auto generate/create using refrence ID from the 1st table. As we can see, there will be an big increment table for day-to-day registration for my website.

    example.

    User register -->
    |----Personal information (1st table)
    |----All the web URL that User had. (2rd table auto create)

    As we can see, we need to keep the web URL that the user have, and the URL will increase in Day By day, Maybe it could reach 100 URL.

    For me, i suggest that i wanted to create a seperate databse to keep these two database. And i would like to know, is it possible to do it? Any benifit doing seperate database for my web development?

    Thanks in advance.
    Joe

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    you mean separate tables? or separate databases?

    separate tables, yes, but i don't see why you need to put them in separate databases

    however, please do not create a separate URL table for each user!!!
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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