Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Limits to open SharePoint 2010 libraries in Windows Explorer

Posted on 2015-02-05
8
Medium Priority
?
1,068 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
8 Comments
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 2000 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

715 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