I need to check if specific document library exists on sharepoint site and I don't know the title of the library, because it is being created dynamically. The only thing I know is RootFolder.Name property of the library, which is also the part of the url.

As libraries collection of the site is pretty big (~20k records) it takes about 90 sec to execute the following code:

public static ClientContext ctx2010 = SharepointHelper.GetInstance(2010);

static void Main(string[] args)
    var lists_ = ctx2010.LoadQuery(
            l => l.RootFolder.Name == "10016193"));


As I understand, this query retrieves all libraries first, then applies the limitation of 'where' clause.

Is there any way to improve performance of the query?

  • What version of SharePoint are you using? 2010 or 2013 ? – Gautam Sheth Sep 4 '17 at 18:18
  • @GautamSheth, Sharepoint 2010, but CSOM API version 16.xxx – Arsinclair Sep 5 '17 at 6:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.