How efficiently are blanks stored for a List in MOSS? RRS feed

  • Question

  • I have a SP List which has around 10 columns and will potentially have thousands of items (divided in subfolders). 40% of the items will have data for all columns, 50% of the items, however will have blanks for 7 or so of these columns.

    My question is if this is inefficiently stored in the back end (is an entry with 3 filled columns taking comparable space to an item which has all 10 fulled columns). I am assuming it is efficient and doesn't store sparse matrices (a relational DB is the backend I think).

    Unfortunately the data must be in the same SP list so there is no way to put them in seperate Lists

    Wednesday, February 16, 2011 10:30 PM


  • Never fear... Blank fields are stored as DBNull values in the database so storage is optimized.


    I trust that answers your question...


    • Marked as answer by Emir Liu Friday, February 25, 2011 2:21 AM
    Wednesday, February 23, 2011 4:59 PM