Results 1 to 12 of 12
  1. #1
    Join Date
    Nov 2003
    Posts
    6

    Unanswered: Storing articles

    Hi,

    This is my first post here. I'd just like to know what's the best way to store articles? Would storing an article in an ntext 16 field in a database be too slow for concurrent users?

    Please advise.
    Thanks.

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    What is your definition of article ? How many articles and what is the average length (or distribution) of the article ?

  3. #3
    Join Date
    Nov 2003
    Posts
    6
    By article I mean by any of those news articles that you see on the web. Let's take this as an example:
    http://news.com.com/2009-1023-963618.html

    Articles won't be too many but will increase over time. About 10 at first, but could go up to a 100 in the future?

    Average article length would be around 700 words I presume.

    It's a membership only section and personally I don't expect it to have more than 10-20 concurrent users accessing the same article at the same time. However, this figure could increase in the future as well.

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    Would you exceed a character length of 8000 (for the varchar data type) ?

  5. #5
    Join Date
    Nov 2003
    Posts
    6
    Few articles might. Another question: Is there a big difference using Varchar 8000 and ntext 16?

  6. #6
    Join Date
    Feb 2002
    Posts
    2,232
    Well that is why I am asking what your distribution is for the length of your articles. For the number of articles you are concerned about, this will not be an issue - I worked with several hundred thousand of articles in sql server and with more concurrent users than you with no problems. However, you need to be more diligent with your error checks on your tables that use them because they are more likely to have errors.

  7. #7
    Join Date
    Feb 2002
    Posts
    2,232
    Are these users reading the article only or are they editing the article as well ? Also, with sql server 2000 you have an option known as text in row which you might be able to use.

  8. #8
    Join Date
    Nov 2003
    Posts
    6
    They only read it.

  9. #9
    Join Date
    Feb 2002
    Posts
    2,232
    You will be ok - however, I would test the length of these articles and see if they are in fact text datatypes or long varchars. If you have a mix you can still use the text in row as well. Just make sure that if you use ntext/text datatypes to make sure that you have a frequent integrity check using dbcc checkdb.

  10. #10
    Join Date
    Nov 2003
    Posts
    6
    Could you please let me know about "dbcc checkdb". I'm not too experienced with MS SQL although I have general DBMS skills and worked with a few of them. What does this command do?

  11. #11
    Join Date
    Feb 2002
    Posts
    2,232
    Both checkdb and checktable check the integrity of the database/table. Since you are new to ms sql, I would recommend that you read the "books online" - this is an online reference utility for sql server.

  12. #12
    Join Date
    Nov 2003
    Posts
    6

    Thumbs up

    Cheers!

    Thanks for the tips!

Posting Permissions

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