Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New Coder
    Join Date
    Dec 2006
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    A seprate database for PHPBB or merge the tables with the site?

    I have a databse for the main website that will contain ~15 tables.
    Are there advantages/disadvantages to merging the phpBB tables with the one from the site or seprating the tables sets in 2 different databases?

    What is generally the best way to go?

  • #2
    Senior Coder Len Whistler's Avatar
    Join Date
    Jul 2002
    Location
    Vancouver, BC Canada
    Posts
    1,323
    Thanks
    26
    Thanked 100 Times in 100 Posts
    I would create the 15 tables in the phpBB database to keep everything together, makes it easier to maintain. I can't see any advantage to create a new database.
    Leonard Whistler

  • #3
    New Coder
    Join Date
    Dec 2006
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Ok, thanks for your input Len.

  • #4
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,634
    Thanks
    4
    Thanked 148 Times in 139 Posts
    You should split data across databases when the data is completely irrelevant. When your data is for your site, as well as a board for your site, then there is no problem combining into the one database.

    Just my two cents on when/when not to split data over databases.

    In short, a ME TOO!


  •  

    Posting Permissions

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