Skip to Content
Professional SharePoint® 2010 Field Guide
book

Professional SharePoint® 2010 Field Guide

by Steve Mann, Colin Murphy, Pablo Gazmuri, Chris Caravajal, Christina Wheeler
February 2012
Intermediate to advanced
456 pages
14h 54m
English
Wrox
Content preview from Professional SharePoint® 2010 Field Guide
332
CHAPTER 10 Building ScalaBle applicationS inSharepoint
object, many programmers assume that you must call SPList.Items.Add(). Actually, you may retrieve
an empty
SPListItemCollection without querying the database by calling SPList.GetItems() and
passing an
SPQuery object designed to return no rows. So to add an item to a SharePoint list, use the
following code instead:
SPListItem newItem = SPList.GetItems(new SPQuery(){Query = “0”}).Add();
This way, no matter how large your list becomes, you can always add new items without incurring a
performance penalty that increases as the list grows.
In addition to adding items, SharePoint programmers sometimes make the mistake of looking up the
number of items in the list using the following method:
SPList.Items.Count
As with the previous example, this code loads all items in the list before returning the count of those
items. To avoid this, instead make use of the
.ItemCount property:
int itemCount = SPList.ItemCount;
When querying list data, unless your code actually needs to iterate over every single item in the list,
you should always use CAML queries to retrieve the list items you need. Just as with list views, if
your query lters on an indexed eld, it performs much better. Furthermore, by specifying an item
limit with your query you can avoid running into query throttling limits.
If the list you try to query is extremely large (mi ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Microsoft® SharePoint® Designer 2010 Unleashed

Microsoft® SharePoint® Designer 2010 Unleashed

Kathy Hughes
Beginning SharePoint 2013 Development

Beginning SharePoint 2013 Development

Steve Fox, Chris Johnson, Donovan Follette

Publisher Resources

ISBN: 9781118105054Purchase book