In last post Working with SharePoint Large List – Part 1, I just showed to you about how to get SharePoint data list by many ways:

– By Object Module with For/Each loop

– By SPQuery

– By DataTable

– By Web Services

– By Portal SiteMap Provider

And in this post, we will review the performance of each via tested result in the charts. It’s also compare Add and Delete Items between Indexed fields, No Indexed Fields and By ID field.

1. Add Item

2. Delete Item

3. Data Retrieval

Data Retrieval with under 1500 Items


Data Retreival around 100,000 Items


Retrieval Data with Indexed Column vs No Index


Data Retrieval By ID vs By Indexed Column

Related Article:
Hoang Nhut Nguyen
Skype: hoangnhut.nguyen