R – Organising large Doc volumes in Sharepoint

document-librarysharepoint

I need to upload into Sharepoint around 100,000 (MS-Word) documents that are currently on a file server – added over the past 7 years. I've read that a sharepoint Document Library should really be limited to 2,000 documents, and that there are performance issues once this is exceeded.

I've thought about creating a Doc Library for each calendar year, but even so, there would still be well over 10,000 Docs in each one…

I read that creating Views on the Doc Libraries would increase performance, but I don't see how this would be. What about adding Indexes??

What's the best solution? Anyone come across this issue?

Best Answer

The soft limit is 2000 per view. The current document library limit for "acceptable performance" is (God help anyone if they get to this): 5 million per library:

http://technet.microsoft.com/en-us/library/cc287790.aspx

Maybe a library per year with a folder (yeah, I know, folders are bad) for each month?

Related Solutions

R – Sharepoint Doc Lib Content Types

You're right; there's no built-in functionality for this. It should be reasonable simple to write a workflow that runs when something is added to a library, checks to see if it is a folder, and adds the items into the folder. It would probably be easiest to have the template documents in another folder somewhere, and then copy them over.

Good luck!

Xml – the correct XPath for choosing attributes that contain “foo”

//a[contains(@prop,'Foo')]

Works if I use this XML to get results back.

<bla>
 <a prop="Foo1">a</a>
 <a prop="Foo2">b</a>
 <a prop="3Foo">c</a>
 <a prop="Bar">a</a>
</bla>

Edit: Another thing to note is that while the XPath above will return the correct answer for that particular xml, if you want to guarantee you only get the "a" elements in element "bla", you should as others have mentioned also use

/bla/a[contains(@prop,'Foo')]

This will search you all "a" elements in your entire xml document, regardless of being nested in a "blah" element

//a[contains(@prop,'Foo')]

I added this for the sake of thoroughness and in the spirit of stackoverflow. :)

Best Answer

Related Solutions

R – Sharepoint Doc Lib Content Types

Xml – the correct XPath for choosing attributes that contain “foo”

Related Topic