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
