SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Jan 2010
    Posts
    15
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Database Efficientcy

    *** So new at this I still have that new car smell ***

    I'm developing a website and I am trying to make it as efficient as possible. Currently I have 2 databases (one for users and another for informational posts).

    When going to the website the posts stored in the database are displayed with various information about the user attached to it (namely the city and state they reside in). What I opted to do is when a user fills out a form to create a post it also pulls these two fields from the user database and attaches that to it.

    The reasoning behind this is so that the site wouldn't have to load the 50 posts to display and then hunt down the user information for each post displayed.

    My question is if this was a wise thing to do or if I'm just uselessly making my databases larger and complicating things?

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,341
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    the latter

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


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
  •