20 key Points Arising, or Inferred, From “Working with large lists in MOSS 2007” Paper
Honestly If I am asked what is the best MS white paper that I have ever seen published for SharePoint? hands down , I would say working with large lists in Office SharePoint Server 2007 White paper. When I first read this paper (not even publicly available ), I was very impressed with the depth of the knowledge , accuracy of the tests and more importantly how the content was organized and presented to the readers. Very interesting and a must read paper IMHO!
I think there are three things that could make this article even better:
1) It doesn’t end with a proper conclusion! The thing is there are so much information presented to the reader throughout this paper, but one argument I often hear is that “Man, I felt dizzy when I finished reading it – too much information!” . It would be great if they could add bunch of statements at the end of the article to kind of conclude the core messaging of the paper. This will help the reader remember key points arising from this fantastic write up.
2) It is difficult to relate the presented best practices to WSS – this paper is written for MOSS 2007 as you can tell from the title! Albeit there are some attempts to draw a border between WSS and MOSS wherever required, but still after you finish reading this paper, it’s not easy to extract some WSS rules.
3) Not a big deal, but I think four of the data access methods could be named better! For example, SPList with DataTable or SPListItems with DataTable – Nope, sorry, it doesn’t ring a bell for me! Maybe they kind of had to adopt this naming convention because of how method names are shown in captions in various charts (short names), but readers often have to refer back to the actual code to recall what that specific data access is all about.
Click on the link below to download the PDF file containing all 20 key points .
Markup is showing up in your list:
20. Even if you have solved all the issues mentioned
@Brian
Thanks Brian for the heads up. Looks like when I published the post using Fire Fox , it screwed up the markup . Put it into a PDF file not to bother reformat using IE 🙂
Do you have the original paper?
the http://technet.microsoft.com/en-us/library/cc262813.aspx doesn’t show it any more …
I have to pick on one statement made in the PDF;
SharePoint stores all the lists of a given site collection in one table in the content DB.
It’s actually worse than this, if you have multiple site collections in a single content DB then all documents are stored in a single table; that is all documents in all document libraries in all sites and site collections that are in that content DB are in a table, the actual content is stored in the dbo.AllDocsStreams table. This is why we try to dedicate a database to a site collection (set max number of sites per database to 1 if you expect that site to contain thousands of items!), instead of many sub webs in large site collections or many site collections in many databases.