I’ve attended, exhibited and lectured at the SPTechCon 2009 in San Francisco this week. I was glad that I was given the opportunity to talk about SharePoint Performance and Scalabilty. I’ve recorded both my classes 602: INTO THE WILD: THE CHALLENGES OF CUSTOMIZED SHAREPOINT APPS IN RELEASE 801: BUILDING SCALABLE, HIGH-PERFORMANCE SHAREPOINT APPLICATIONS Samples that I’ve [...]
Application Performance, Scalability and Architecture
Have you ever wondered what is really going on under the hood when you index a column in SharePoint? Everybody keeps talking about indexing columns once your lists exceed the 2000 items limit. Knowing that everything in SharePoint is basically stored in one single table made me wonder how indexing individual columns is actually implemented. [...]
I am going to host two presentations at the SharePoint Technology Conference in San Francisco this week. In case you attend the conference you may want to check out the following two sessions that I will do: 602: INTO THE WILD: THE CHALLENGES OF CUSTOMIZED SHAREPOINT APPS IN RELEASE 801: BUILDING SCALABLE, HIGH-PERFORMANCE SHAREPOINT APPLICATIONS The [...]
We all know that SharePoint list performance can degrade the more items are stored in the lists and depending on how the lists are filtered when viewed. You will find many arcticles and blog entries talking about the 2000 items per list limit. The 2000 items however are not the real problem – you can in [...]
In my previous posts about SharePoint I focused on how to improve read-access of items stored in SharePoint lists. Now its time to discuss how best to update or add new items. As the SharePoint Object Model provides a big variety of interfaces we can again choose between multiple approaches. Scenario 5: Updating a large [...]
SharePoint lists can contain thousands of items. We have all heard about the 2000 items limit that should not be exceeded in order to achieve good list performance. There are definitely performance impacts when exceeding this limit and there are ways to overcome this limit by using indexed columns and views. Besides these considerations its also [...]
One of the main performance problems that we can witness in any type of application that has to deal with data from a database is that too much data is requested. Requesting more information than actually needed by the current use case on hand results in additional query overhead in the database to gather the requested [...]
There are multiple ways to iterate through the items of a SharePoint list by using the SharePoint Object Model. One approach – which I’ve seen before in a real life SharePoint Application – may work fine on the developers machine or on very tiny lists. But it is going to ruin your performance once executed [...]
The SharePoint Object Model allows external applications or hosted WebParts to query, modify and create the content which is stored in the SharePoint Content Database. You will find many blog entries, knowledge base articles and best practices about how to correctly use the Object Model for different use case scenarios. I am going to write [...]
In the first post for this year, I will discuss an interesting question: “How to find invisible performance problems”. What makes up an invisible performance problem? An invisible performance problem is an inherent problem in your code, which does not yet manifest in externally observable problems like slow response times, high CPU load or the [...]
