SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Wizard jonese's Avatar
    Join Date
    Jul 1999
    Location
    Powder Springs GA (Atlanta)
    Posts
    1,238
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ok i'm on VServers. with my account (the pro) i get to have mySQL and PHP. in the mySQL i can create db's tables etc. all from an admin screen so it's really easy (a plus for a db idiot)

    my question is how should i go about doing things. ie should i do a db for each item (articles, reesources, etc) or should i do a db for each site and then tables for thee differant items in that site?

    i'm concerned about speed and makeing it easy to implement.

    any help would be most greatful

    ------------------
    Eric Jones - WR Moderator / Administrator
    http://www.computermoles.com
    "Digging up the best in computer software!"


  2. #2
    SitePoint Enthusiast
    Join Date
    Feb 2000
    Location
    Grand Rapids, MI
    Posts
    61
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm going to take a stab at this, or atleast give my opinion.

    For coding ease, I would say put everything into one database, using different tables. I don't know of any table limitations with MySQL, and the two gig file size limitation of Linux won't be hit (unless you've got two gigs of server space)

    Another way may be to do it like I have it setup, where most of the site is under one db, with features that don't coincide with most of the site (such as message forums, search engine database) under different db's.

    But I guess it doesn't really matter either way.

    Mike

  3. #3
    RAGE
    SitePoint Community Guest
    from experience, db / site seems to be most efficient ..

    since you can later, in the future dump the database contents to a file, etc, and that cant be done for multiple db's unless you're an admin


    ------------------
    Vinay Sahni, Coder .. specializing in php/mysql
    webmaster@realmz.net

    http://www.realmz.net
    Your #1 source of Webmaster Resources


Bookmarks

Posting Permissions

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