SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Wizard jonese's Avatar
    Join Date
    Jul 1999
    Powder Springs GA (Atlanta)
    0 Post(s)
    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
    "Digging up the best in computer software!"

  2. #2
    SitePoint Enthusiast
    Join Date
    Feb 2000
    Grand Rapids, MI
    0 Post(s)
    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.


  3. #3
    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
    Your #1 source of Webmaster Resources


Posting Permissions

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