Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2003
    Posts
    20

    Unanswered: lots of tables in one database or multiple databases

    I am working on a project to combine 3 separate web sites into one site.

    Each has a separate mysql database with separate tables.

    Some tables, like the user table, are duplicates and have to be merged.

    I am planning to put all the tables in one big database. I wonder if anyone knows of an advantage to keeping the tables in separate databases instead of combining them into one database?

    thanks for any replies.

    Jon

  2. #2
    Join Date
    Jun 2003
    Posts
    9

    Re: lots of tables in one database or multiple databases

    One option where multiple tables could be used is when u have very large tables. Obviously this is not the case here.

    Cant see much against a single table as multiple queries will be required to extract a record from the multiple tables.

  3. #3
    Join Date
    Jun 2003
    Posts
    21

    Re: lots of tables in one database or multiple databases

    Originally posted by jbroder
    I am working on a project to combine 3 separate web sites into one site.

    Each has a separate mysql database with separate tables.

    Some tables, like the user table, are duplicates and have to be merged.

    I am planning to put all the tables in one big database. I wonder if anyone knows of an advantage to keeping the tables in separate databases instead of combining them into one database?

    thanks for any replies.

    Jon
    Seperate databases/tables would provide better security.

    Seperate databases/tables would be easier to port to another system if necessary in future.

    Seperate databases/tables will be harder to maintain.

    Niels

  4. #4
    Join Date
    Jun 2003
    Posts
    20
    thanks for the replies.


    focusing on the multi-db vs. single-db question:


    re: Seperate databases would be easier to port to another system if necessary in future.

    can you elaborate?

Posting Permissions

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