0
votes
3answers
32 views

Best way to cache large SPList for users with security trimming

The scenario: There are performance problems around viewing a large list with several thousand items. I want to cache it to reduce the query to the database. Users need to be able to see this list, ...
0
votes
1answer
252 views

Bestway to store and manipulate SPListItemCollection results

I get a SPListItemCollection in my program. I use this collection to show the items in a DataGridView display. I need to filter items based on a requirement. But .Add() or Delete() does changes to ...
0
votes
1answer
322 views

SPListItemCollection slow

I have a list with over 150k records. I'm doing a filter to get only 1 record via CAML, only sort by a particular column, and this is it takes at least 15 seconds for me to have this return, which is ...
0
votes
4answers
2k views

How to get count of list items in SharePoint 2010 if count is more than List View Threshold value?

I have more than 10000 items in my list. I have default List View Threshold value as 5000.I want to get the count of items programmatically. How can I get the count? I think here ...
0
votes
1answer
397 views

Proper way to evaluate/get status of boolean field when looping through SP List with code

What is the best way to do this when looping a list? I have tried to evaluate it with something like this but it wont let me evaluate bool as an "if" condition if (item["ShowTitle"] == true) //do ...
0
votes
1answer
263 views

Double value in URL from SPListItemCollection result

I have a basic list which I am using to generate a "Quick Links" menu WebPart. It looks ok but for some reason the URL field (of URL type) when rendered renders html that looks like this: <a ...
1
vote
1answer
994 views

When to use List<SPList> vs SPListCollection?

If I have to grab numerous lists which I have the name, URL or Guid of, should I use web.Lists and return the entire SPListCollection or grab the specific ones I need via web.Lists[Guid] and place ...