.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Large lists unmanageable in Standard View?

Posted By:      Posted Date: October 14, 2010    Points: 0   Category :SharePoint

I'm migrating some content from a SharePoint 2007 environment to a SharePoint 2010 environment. As it's not much, I've opted for simply recreating it and migrating it manually. In this process I've got a few large lists.

In a list with 40 columns and 1500 items, I had to use Datasheet view to view it properly. The original view in the SharePoint 2007 version was datasheet too, so not a problem there. However I did notice that a standard view was completely unusable, it just soaked up memory and utilized one core of my dual core cpu to max, doing practically nothing. All I could do was close the IE instance.

In another list, with around 30 columns and 600 items, I noticed that the original was a standard view. So I created a standard view in SP2010 as well. However this view is quite sluggish, not at all as smooth as the SharePoint 2007 counterpart.

My quick findings are that I must use Datasheet view for all large lists in SP2010. Have you come to the same conclusions, or is there a another way of displaying large lists in Standard View?

View Complete Post

More Related Resource Links

How can I get it back to a standard view?

I already convert the standard view from Sharepoint to XSLT Data View. I also change the column width, how can I get it back to a standard view?

Form Display is very slow to display, (using large multi-select lists)

Hi, I am looking for some suggestions on how to speed up a few very slow forms. We have created some Leaver and Joiner type forms for our IT guys. They contain some lookup data , and we need to pick multiple values from a hidden list. Unfortunately this (Systems/Roles) list is large (3000 rows and growing). On a couple of forms there are 2 of these multi-select boxes, and things are getting pretty slow to display. Any suggestions? ---------- Background Info / things I have tried: The forms are based on Site content types and Site Columns. A set of 5 Combo boxes is slower than one Multi-select list. SPDesigner is available but I do not have Central Admin rights I am not alowed to write/install custom code on the server. (Visual Studio code / Codeplex code / extra Features etc) :-( I have had to resize the Multi-select list, so am using the SPServices JQuery call to make the multi-select box wide enough for the text. But this is extra overhead so I might have to back that out / replace with a fixed width for the multiselect box (if I can find it's id, so I can do that in Javascript). Filtering the Multi-select box is possible, but only after the page has initially loaded (it seems) (again I tried the SPServices Jquery call) The Company intend to add more Content types, so I am trying to avoid a custom Newform.aspx for each type (Leaver / New Joiner / Transfer/ C

Columns in Doc Library Standard View are not seen in Datasheet View


All the columns appearing in the Standard view of my doc library are not appearing in the Datasheet view. I've look through all the information I have and it all it appears to indicate that boht views sould match:

Office and SharePoint 2007 User's Guide, by Michael. Antonovich published by Apress-
" . .this view displays the same information as the Standard view."

SharePoint 2007 by Ishai Sagi, published by SAMS- "The Datasheet view displays all the columns that were on the standard view."

In the Standard view these columns appear: Type,Name, Checked Out To, Check-In Comments, Modified, Modified By and Version.

Yet in the Datasheet view of the same library these columns appear: Type,Name, Checked Out To, Modified,and Modified . The Check In Comments is missing and the Version column are missing.

I don't see this same problem with lists imported from a spreadsheet.  In those instances the Standard View and the Datasheet view are an exact match.

Any ideas?
Thanks so much!

Is it possible for a sharepoint VIEW to aggregate multiple TASK LISTS?


I have a few TASK LISTS, each with identical structure, that can't be combined initially, based on the groups that control the task lists.  ALL Task Lists reside on the same SITE.  I would like to find a way to "UNION JOIN" multiple task lists under a single Tasks List VIEW, if that can be done.  Alternately, is there a WEB PART that can do this?

Is there a way to merge multiple similar-structured task lists within a single site - and if so, how would it be done?

"More" option for Summary view on lists


I'm not sure if this is the correct area to post this question or if it's more of a design question but...

I noticed with 2010 that when lists such as announcements and links get beyond a certain quantity that the Summary view within the webpart shows a "More" link even if the webpart is set to only show say 5 items.

I've checked the XSL stylesheets and can't find any entries that would specify to show the More link once a list grew to a certain point. I've also checked the web part, list, and view settings to no avail. Any suggestions?

Sharepoint Foundation - Create and deploy custom edit/view forms for external lists


Firstly, we are using sharepoint foundation so Infopath forms are not an option for us.

We have a Visual Studio sharepoint project which deploys a complete sharepoint site. The site contains a number of external lists and we want to be able to create customised view/edit forms for these lists and add them to our Visual Studio project so they can be deployed as part of the new site. The idea is that we can deploy the solution to a fresh site with a default set of forms which can then be customised for different implementations of the site.

Here's the steps we have been using to try and do this:

1. Deploy the base project (BDC) to the sharepoint site

2. Create external lists based on the BDC content types

3. Use Sharepoint Designer to create new edit/view forms for the lists and set these as the default forms for the list

3. Save the site as a template

4. Import the template into a new Visual Studio project and select the lists we require. This gives us a List Definition, a pages module (with element file), an elements file and a schema file (both for the List Instance).

5. We then add the contents of the imported project to our main solution as follows:

  • Create a new List Definition (including List Instance)
  • Copy the contents of the imported Elements.xml to the Elements file for our List Instance.

Datasheet view, I get this error message: The lists are access DB lists.

  When I try to edit any of the lists by typing directly in the Datasheet view, I get this error message: The lists are access DB lists.

"An unexpected error has occurred. Changes to your data cannot be saved. For this error, you can retry or discard your changes."

I get this error message when I try to
1. add a new row by typing directly in the Datasheet view,
2. edit an existing row by typing (or selecting from a dropdown menu) directly in the Datasheet view, or
3. delete a row by right clicking on a row and selecting Delete Rows.

The error does not occur when I add new items to a list in the Datasheet view by clicking on one of the dropdown menus at the top of the list (such as New, and selecting New Item; or Actions, and selecting New Row). Using these options works fine for adding new rows, but I see no way now to edit or delete existing rows.

The problem seems to have developed sometime in the past few weeks.
I'm using Internet Explorer 7 with Windows XP Professional, Version 2002, Service Pack 3.

Indexed Views are supported by SqlServer Standard Edition - why do all feature lists state the oppos


Hi there,

years ago I had already wanted to apply indexed views for a certain query tuning problem, but read that they are only supported in SqlServer Enterprise Edition. I came back to that topic recently, and again all the official documentation I found confirms that assumption (e.g. http://msdn.microsoft.com/en-us/library/cc645993.aspx).

I gave it a try anyway, and could easily create indexed views on Standard Edition. I checked the execution plans, and the view's indizes were applied. The only small restriction I encountered was, that I had to supply a "with (noexpand)" query hint in the from clause. It even works on SqlServer 2000 Standard Edition.

This is such a valuable feature, probably seldomly applied, because articles and postings everywhere imply that Enterprise Edition is a requirement. I suppose it would be a good idea to correct Microsoft's documentation on that topic. Thank you!

Kind regards, Arno

Show filtered data from multiple data lists in a view


I am attempting to build a very simple Sharepoint site with 3 data lists: 1) Themes,  2) Value Statements, 3) Supporting Details

Each Theme has 2+ Value Statements and each Value Statement has 2+ Supporting Details. 

Currently, I have the Forms setup so that when I enter a new Supporting Detail, the individual must select from the avaialable Value Statements (using a Lookup Column). 

What I would like to do, now, is allow an individual who is looking at a view of all the Value Statements to see the Title field of all the Supporting Details that have been entered for that particular Value Statement (with hyperlinks).

I'm guessing that I need to use SharePoint Designer 2010 to customize the view, but am not certain how to do it from there.


The list is displayed in Standard view. It cannot be displayed in Datasheet view for one or more of


The list is displayed in Standard view. It cannot be displayed in Datasheet view for one or more of the following reasons: A datasheet component compatible with Windows SharePoint Services is not installed, your browser does not support ActiveX controls, or support for ActiveX controls is disabled.

Hey guys I have this showing up on my list that I can not see the Datasheet view. I have added sharepoint as a trusted site, enabled all my active x controls, I have update internet explorer 8, working on windows 7, and have installed office 7. I dont understand whats going on here. It works for the majority of our employees, but not all. Is there something I'm missing.

I've googled the ____ out of this and have seen this issue being talked about around 2007 but nothing recently so im guessing there is an answer out there that I havent found. Please help

how can a standard sharepoint user view storage space

how is a sharepoint user able to view the amount of data avaible and used?

Getting the Item Count of a View. Fast. For a Large View.


I am trying to get the count of the items a view contains programatically. The scale I am working with is 30-50000 items views. I came up with two ways of doing that. Rather unfortunately both of them lack in performance.

1) Create an SPQuery based on the SPView Query property. Set the SPQuery.ViewFields property to return just the ID field (best performance that way) and set the query RowLimit to uint.MaxValue. Invoke SPList.GetItems with the query as an argument. Then get the Count property of the SPListItemsCollection object returned.

The query runs pretty fast (milliseconds on VM) up to the point where I try getting the Count property of the SPListItemCollection. That takes like 10 seconds. It feels as if it's actually enumerating the collection.


2) Create a SPSiteDataQuery along the same pattern as above. Run it on the list where the view is defined. Get the Rows.Count property of the returned DataTable. 

It's the query that takes like 10 seconds to complete in this approach. So I am pretty much getting the same speed as in the previous approach.



So, can you guys think of some other way that I can get the count of items in a view? A faster way than the ones above?

Changing a Web Part Lists default view


I have created a new view for my Shared Documents, document library, called TestView. Currently the default view of this document library is "All Documents". I want to change the defualt viewto TestView. So far I have the following code:


list.Views["TestView"].DefaultView = true;



This doesn't work. When I navigate to my document library the current (and default) view is still "All Documents". How can I change this?



After applying custom master page, "Current View" drop down is no longer functional on Lists


The "Current View" drop down is not dropping down anymore when on the list library ribbon with a custom master page applied. Of course, it does work fine with v4.master. I would list all the custom master page changes however they are numerous. So I am looking to see if there are any ribbon experts that can give me things to at least look for. I would really appreciate it! Thanks!

Create view by getting data from different lists.

I want to create a view by getting data from 3 different lists.Is it possible to create a view like that?

disable the hyperlink in the lookup field in standard view

hi, is there a way to hide the hyperlink in lookup fields that appear in the allitem.aspx for example, I do not want the users to click on the lookup field as it might bring them to another list, but I do not want it to be hidden as well.

Display data from two lists in a single Data View - how to edit/delete/view items?


I have an aggregate dataview from two lists. (something like this http://office.microsoft.com/en-us/sharepoint-designer-help/display-data-from-multiple-sources-in-a-single-data-view-HA010099144.aspx#BM3)

The problem is, that when I click on "Data view properties", the options in Editing tab (edit link, delete link and view link) are greyed out.

 I'd like to create custom delete/edit/view link for rows in that dataview with linked source. Any idea?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend