SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    get back to rowing khu19's Avatar
    Join Date
    Jan 2003
    Location
    New York / Boston
    Posts
    593
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Lightbulb Where to store articles in CMS

    I need to develop a small simple CMS to manage my news updates and articles written for the website. How should the articles be stored, considering they may be multiple pages. Should the text be stored in a database (MSSQL) or as an html file and filename information stored in the database?

    Wouldn't storing the actual articles in the database take up a lot of server resources? Thanks,

    Kevin

  2. #2
    Sultan of Ping jofa's Avatar
    Join Date
    Mar 2002
    Location
    SvÝ■jˇ­
    Posts
    4,080
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Wouldn't writing/reading the article to/from an html file take up a lot of server resources?
    I vote for storing the articles in the db.
    Makes it easier to control which articles different user groups can read too.
    If an article can be more than one page, use one table for article data, and another table for sections of an article (fk article id).

  3. #3
    get back to rowing khu19's Avatar
    Join Date
    Jan 2003
    Location
    New York / Boston
    Posts
    593
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    What type of datatype should the column be (for the text of the article) ?

  4. #4
    Sultan of Ping jofa's Avatar
    Join Date
    Mar 2002
    Location
    SvÝ■jˇ­
    Posts
    4,080
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    text (or ntext)

    Quote Originally Posted by Sql server documentation
    ...values too large to fit in the row are stored in a collection of pages separate from the pages holding the data for the other columns of the row.
    ...
    Although the user always works with text, ntext, and image data as if it is a single long string of bytes, the data is not stored in that format. The data is stored in a collection of 8-KB pages that are not necessarily located next to each other. ...
    I.e. the value stored in the table isn't the text, it's a reference to the location where the text is stored
    Simplified picture: sql server stores the "filename information"

  5. #5
    SitePoint Enthusiast
    Join Date
    Aug 2002
    Posts
    25
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Check this out. It works great for our company:
    http://www.interactivetools.com/prod...rticlemanager/


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
  •