Results 1 to 5 of 5

Thread: Should I use more than one database?

  1. #1
    Join Date
    Nov 2007
    Location
    Nashville, Tennessee
    Posts
    249

    Question Should I use more than one database?

    Hello Brian,

    Here is my scenario:

    I'm running vBulletin for my Forums.
    I'm running two instances of vBa Dynamics for my Articles & Media sections (I may eventually run a third instance.)
    I have vBa Links Directory also integrated.
    Now I'm getting ready to install PhotoPost Classifieds.

    My question is this - should I just be running ONE database to handle the functionality of all this, or should I run more than one, and what is the reasoning for that?

    With my host, it doesn't cost any more to add additional databases, if there is a reason to do that. I honestly don't know much about databases, but my thinking also is that running only one is easier to backup through the AdminCP on vB.

    Please advise me on how you would structure it, for optimal performance, longevity, and maintenance.

    Thanks a lot!
    Jeff

  2. #2
    Join Date
    Mar 2004
    Location
    A galaxy far, far away...
    Posts
    6,609

    Default Re: Should I use more than one database?

    All of the vBadvanced products are meant to use the same database that your vBulletin installation is using; trying to use different databases would require changing a bunch of code.

    For now... just go with the one database method.

  3. #3
    Join Date
    Nov 2007
    Location
    Nashville, Tennessee
    Posts
    249

    Question Re: Should I use more than one database?

    Alright Kevin. Thanks for the tip. I just thought that maybe with that many different applications storing data to the same database, it might be more efficient to have a few job-specific databases instead of one collective.

    Another related question - is there a downside to storing image files/attachments in the database vrs. to a folder of some sort? Can both vB and vBa use either option? If I want to store to a folder, how do I do that? Do I have to chmod the folder to 777?

    Thanks for the help!
    Jeff

  4. #4
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default Re: Should I use more than one database?

    If you think that you're PP classifieds software is going to have more than a thousand or two classifieds submitted, then it may be better to go ahead and install that to a separate database. I doubt that there would be much of a difference performance wise, but it couldn't hurt, and it's usually easier to manage a few smaller databases for backups and such instead of one large one.

    As for storing images in the database, I would not recommend that. Images take up a lot more space than text and storing them in the file system should be much easier on your server. vBa products should work fine with either storage method, so you shouldn't have anything to worry about there. As for moving them, you should just need to go to Admin CP => Attachments => Attachment Storage Type and follow the instructions from there.

  5. #5
    Join Date
    Nov 2007
    Location
    Nashville, Tennessee
    Posts
    249

    Default Re: Should I use more than one database?

    Thanks for the advice Brian!
    Jeff

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Database
    By attroll in forum Feedback & Suggestions
    Replies: 1
    Last Post: 03-24-2007, 01:12 PM
  2. database error
    By joggele in forum Troubleshooting & Problems
    Replies: 1
    Last Post: 10-23-2006, 07:13 AM
  3. INDEXU database
    By aacircle in forum "How Do I..." Questions
    Replies: 2
    Last Post: 12-06-2005, 10:18 PM
  4. Database Error
    By deaconxgp in forum Troubleshooting & Problems
    Replies: 2
    Last Post: 11-29-2005, 08:36 PM
  5. How Do I.....Database
    By nubian in forum Chit Chat
    Replies: 1
    Last Post: 12-09-2004, 12:35 PM

Posting Permissions

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