Performance – various methods to retreive one list item


A few months ago we had a workshop on MOSS from our ADC, and one of the topics he talked about was the performance in retrieving list items. This is so important for the performance of a website, so when I found the post from Waldek Mastykarz on the same subject I just had to highlight it.

Just a quick peek, the methods tested were:

  • SPQuery on the list instance
  • GetItemById(int) method
  • SPSiteDataQuery on the parent Web
  • SPSiteDataQuery on the parent Web passing the List ID (using the SPSiteDataQuery.Lists Property)
  • CrossListQueryCache
  • PortalSiteMapProvider

Waldek then explains each approach and event illustrates graphically the differences . . .

Computer developer/consultant from Portugal. You can find me at ricardo.magalhaes@gmail.com

Tagged with: , , , , , ,
Posted in Sharepoint

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: