Solved

Limits to open SharePoint 2010 libraries in Windows Explorer

Posted on 2015-02-05
8
800 Views
Last Modified: 2015-02-14
Hello,
Does anyone know if there are limitation on the number of items in a SharePoint 2010 document library that would prevent it from opening in Windows Explorer?
I can open a library with 33K+ documents but am having a problem with a library where there are 100K+ files.
No errors in the Events or System logs.
Should I follow this article
http://www.mysharepointadventures.com/2011/08/unable-to-browse-large-document-library-in-explorer-view/
Solution

The problem occurs because the size of all the file attributes that are returned by the WebDAV server is much larger than what is expected. By default, this size is limited to 1 MB.

To work around this problem, you need to modify the windows registry on the client computer.

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\WebClient\Parameters\
 Value:
 FileAttributesLimitInBytes
 Data Type: DWORD
 Default Value: 1,000,000
 decimal (1 MB)

Change the default value to a larger number, e.g. 100000000 for 100mb.


Thanks!
0
Comment
Question by:IT-NYC
  • 5
  • 3
8 Comments
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 500 total points
ID: 40592297
Hi,
as the explorer view uses the WebDAV feature and the webclient service on the client side, there are some default settings in Windows 7 like default timeout and maximum upload size mentioned in this MS KB entry:
http://support.microsoft.com/kb/2668751

Besides that the general considerations for large lists and libraries will take account in regards to performance.
HTH
Rainer
0
 

Author Comment

by:IT-NYC
ID: 40594762
Thanks, Rainer!
I will try and let you know.
Have you tried opening libraries with the number of files I mention?
0
 
LVL 44

Expert Comment

by:Rainer Jeschor
ID: 40594871
Hi,
nope - I always tried to keep the libraries / folders on a reasonable size (max 5000 elements on one level).
Too many bad experiences from colleagues and customers who did not follow this approach :-)
But there are also other factors to consider e.g. item level permissions - this can kill performance as well (my first experience on SP 2010 saying you can have thousands of documents and you can have item level permissions - but it seems that nobody really tested the combination of both :-D)
HTH
Rainer
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:IT-NYC
ID: 40594909
I hear you loud and clear, been there.
In my case, it is a combination of large number of folders and files. Will see it on Monday. I am optimistic :)
0
 
LVL 44

Expert Comment

by:Rainer Jeschor
ID: 40594920
Good luck - and have a nice weekend
0
 

Author Comment

by:IT-NYC
ID: 40594932
You, too.
0
 

Assisted Solution

by:IT-NYC
IT-NYC earned 0 total points
ID: 40599313
It worked!!!
Thanks a lot
I applied the registry setting: FileAttributesLimitInBytes to 100000000
and FileSizeLimitInBytes 200000000
in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\WebClient\Parameters
and
FsCtlRequestTimeoutInSec to 3600 in HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\MRxDAV\Parameters
In IE, modified Compatibility settings as it wasn't opening from the menu (you have to add this site to the Trusted Sites message).
0
 

Author Closing Comment

by:IT-NYC
ID: 40609526
Part of the solution was my own findings.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I recently came across an issue with a MOSS 2007 deployment where access into some sub-sites were denied, even for the MOSS farm administrators. A bit of background to the setup of this MOSS farm; this was a three server setup, consisting of a fr…
Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

680 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question