Common mistakes in Sharepoint Development

I was sent an interesting article today about performance issues in Sharepoint Object Model Code.  There are some interesting points in there, particularly with regards to how to structure code to minimise database calls.

InfoQ: SharePoint Object Model Performance Considerations

It is important to realise that a lot of these mistakes would be quite easy to make, particularly for a developer more used to the windows forms environment.  One I was quite taken by was when they pointed out that each discrete time the “items[]” element was accessed, if the results weren’t stored, it trigger a complete rowfetch from the database.  That sort of thing, used in the standard way in a loop, could cause an awful lot of database access.

Advertisements

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