SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to create a list which can store SPItems for "offline" reference.

I would hope no more than 3000-6000 items.

Do you think this is pushing it memory wise?

Thanks in advance

share|improve this question
How many columns and what type of columns? – Kit Menke Sep 21 '11 at 21:00
What do you mean with "offline" reference - just store the list as a file or something on the disk? – Wictor Wilen MCA MCM MVP Sep 22 '11 at 6:23
up vote 2 down vote accepted

I just saved a list as a dataset and converted to an xml recordset into a text file. This list contains 15 custom columns with several of them being lookup columns. It has 2345 items in list. The file ended up being almost 7 MB. This might give you some hint into the size.

share|improve this answer

3000-6000 items in a list is not much for SharePoint which can scale to very very large amounts of items.

Of course working with a large items takes its special toll. For instance SharePoint has built-in throttling that (by default) stops you from retreiving more that 5.000 items at once. You need to make sure that you query the list smart to retrieve all items. Displaying views with a "lot of items" can degrade performance severly, etc etc

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.