SharePoint is a great platform that makes it easy to customize the portal view for users to their individual needs. Many times though the out of the box Features, Lists and Web Parts are not enough. So you either buy 3rd party extensions or you build your own. One specific problem area with SharePoint is [...]

In SharePoint you can define lookup columns in your lists. The definition of a lookup field allows you to pick the target list and the target column to display in your lookup column. If I have a Product Group list and a Product list, I define a lookup column in the Product list to reference the [...]

In my previous post I took a closer look into SharePoint indexed columns and tried to find out what is really going on under the hood. We’ve learned that indexed columns are actually implemented by populating all values of the indexed columns into the NameValuePair table and that this table is then JOINed with the [...]

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 [...]

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 [...]