2

What is a reasonable level of performance I should expect from querying a very large list in Sharepoint 2010? My list is only 1000 items and after a few days of looking at Sharepoint performance dos and don'ts I still couldn't determine what a good performance benchmark should be.

A project that I am working on was started and designed using Sharepoint 2010 with a list layout structured as a relational database. I think the original expectation was to use Sharepoint to take advantage of out of the box search and versioning functionality and to use spmetal and the repository pattern for data retrieval. I am having horrible performance under load (or what I would think would be horrible performance as I am used to using sql server). Queries on a list of 1000 items using spmetal and 20-30 users are taking 10-15 seconds to load. I decided to just go bare bones to see what I could get. Below is the code.

SPQuery query = new SPQuery();
query.Query = "<View><ViewFields><FieldRef Name=\"ID\" /></ViewFields></View>";
query.ViewFieldsOnly = true;
query.RowLimit = 1000;
SPList list = web.Lists["Incidents"];
var items = list.GetItems(query).OfType<SPListItem>().ToArray();

Item Count: 1000 Average Time: 1197 millseconds

Is this good performance? This is only one call, no other queries to the Incidents list at the same time..nothing.

Steve Anderson
  • 19
  • 2

1 Answers1

0

Yes, it's average performance, at least for a all in one farm.

Leff
  • 582
  • 3
  • 12
  • Currently the database and application are separate servers. Do you have any ideas of increasing performance without the extra servers? I have tried indexing the list field to no avail. – Steve Anderson Jan 22 '13 at 15:53
  • I guess, the only way is to optimize the query itself, and add appropriate indexes to the list. – Leff Jan 23 '13 at 06:27