Coding all day, every day.
4 05 2012
I haven’t posted on this for a while as I’ve been neck-deep in a fairly decent sized Business Intelligence project in SQL Server Analysis Services 2008 R2, but have subsequently learnt an enormous amount with regards to performance. So I thought I’d share a list of the biggest things I’ve learnt from various places (mostly […]
8 10 2011
Disclaimer: The examples shown in this post are extremely unrealistic in terms of real-life scenarios. The numbers and types of fields used in these experiments are designed purely to test the physical limitations of SharePoint. At no point is it suggested that a real-life use of such list architecture be used. If you do have lists […]
8 07 2011
As part of my series of blog posts on item level permissions, I thought I’d post a quick note on “resetting” item-level permissions on a list. This can be done using the method SPListItem.ResetRoleInheritance() on the list item in question. This will reset any item level permissions on this item to inherit from the List […]
9 06 2011
As part of my series on performance, I thought I’d look at updating large (20,000 item) lists in bulk, and what are the fastest ways to do this. I’ve gone through a few different ways of doing this, finding out where the slowness is coming from, and I present the results of the analysis in […]
23 03 2011
So why the hell’s it so slow?This post follows on from my last one when I looked at the developer dashboard to gain insight into where the performance issues came from when you have a large list with lots of item level permissions. In this post I’ll take a deeper look, using the SQL Server […]
10 03 2011
Tonight’s little project was inspired by a conversation on Twitter with @WonderLaura and @Toddklindt. Laura had asked about the implications of lots of item-level permissions in a big list in SharePoint (here), to which Todd replied with this, and followed up with this and this. So this got me thinking: where is the performance bottleneck […]