locked
Storing data in XML files or SQL Server 2005? RRS feed

  • Question

  • User1451004271 posted

    Hi,
    Using ASP.Net 2.0, SQL Server 2005 we are developing a portal.
    Portal features include forum and articles and many others.

    With respect to forums and articles, which is the best practice, whether store the data in the SQL Server 2005 or in XML files?

    Thanks!
    Som

    Sunday, July 6, 2008 1:11 AM

Answers

  • User-1179452826 posted

    I'd go for database and not xml files. The problem with xml is that during search, everything needs to be parsed. Whereas in SQL 2005, you can have indexes and relations which speed up searches a lot. And I think you'd want searches to be faster for the type of site you're targetting.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, July 6, 2008 2:06 AM
  • User-1346602782 posted

    as the data you store thru  the forum is much bigger iin size ,

    it is better to store it in SQL server.

    More over you have many advantages of handling the data.

    Then you can convert sql data into xml very easily

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, July 7, 2008 1:19 AM

All replies

  • User-1179452826 posted

    I'd go for database and not xml files. The problem with xml is that during search, everything needs to be parsed. Whereas in SQL 2005, you can have indexes and relations which speed up searches a lot. And I think you'd want searches to be faster for the type of site you're targetting.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, July 6, 2008 2:06 AM
  • User1451004271 posted

    Thanks a lot for your suggestion.

    We'll implement the same. 

    Monday, July 7, 2008 12:59 AM
  • User-1346602782 posted

    as the data you store thru  the forum is much bigger iin size ,

    it is better to store it in SQL server.

    More over you have many advantages of handling the data.

    Then you can convert sql data into xml very easily

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, July 7, 2008 1:19 AM
  • User1451004271 posted

     Oh! That's correct. Thanks a lot!
     

    Monday, July 7, 2008 3:44 AM