Accessing List Items:
It is always good if we get the Items collection and then loop through each item in collection, rather than using Item Collection object in for loops.
Bad Coding:
SPList list = SPContext.Current.List;
for(int i=0;i<list.items.Count;i++)
{
SPListItem listItem = list.items[i];
}
SPListItemCollection items = SPContext.Current.List.items;
for(int i=0;i<items.Count;i++)
{
SPListItem listItem = items[i];
}Note:Most of us will get complete item collection then we later check a condition.It is good practice to get only necessary rows and columns rather then complete collection,which will improve the performance as well.Using SPQuery to get specific rows:
SPQuery query = new SPQuery(); query.RowLimit = 100;//Limiting the number of rows to retrieve. SPListItemCollection items = SPContext.Current.List.GetItems(query);
Using SPQuery to get specific Columns:
SPQuery query = new SPQuery(); query.ViewFields = "<FieldRef Name='ID'/><FieldRef Name='Name'/>" SPListItemCollection items = SPContext.Current.List.GetItems(query);
Always check with SPDisposeCheck tool to avoid unnecessary memory leeks.
SPDisposeCheck:
It is good practice to run all your projects through SPDisposeCheck tool before doing any deployments.
No comments:
Post a Comment