SharePoint 2013 list test on Big Data

This article mainly introduces the efficiency of the Sharepoint list library. It has always been thought that the value is 5 K, which will decrease linearly and needs to be stored in folders. Maybe this is the description of the previous version, however, if version 2013 passes the test, this is not the case.

Next, we will briefly introduce our testing process:

1. Create a test list, such:

2. Create a console program and add the data insertion Code as follows:

3. Added code:

using (SPWeb web = site.OpenWeb()){    SPList list = web.Lists["Data Test"];    StringBuilder sbDelete = new StringBuilder();    sbDelete.Append("<?xml version=\"1.0\" encoding=\"UTF-8\"?><Batch>");    for (int i = 0; i < 2; i++)    {        sbDelete.Append("<Method>");        sbDelete.Append("<SetList Scope=\"Request\">" + list.ID + "</SetList>");        sbDelete.Append("<SetVar Name=\"ID\">New</SetVar>");        sbDelete.Append("<SetVar Name=\"Cmd\">Save</SetVar>");        sbDelete.Append("<SetVar Name=" + "\"urn:schemas-microsoft-com:office:office#Title\">Test Data " + i.ToString() + "</SetVar>");        sbDelete.Append("</Method>");        Console.WriteLine("Num. " + i.ToString());    }    sbDelete.Append("</Batch>");    Console.WriteLine("Start Time:" + DateTime.Now.ToString());    web.ProcessBatchData(sbDelete.ToString());    Console.WriteLine("End Time:" + DateTime.Now.ToString());    Console.WriteLine("Data Insert complate...");}

4. View and add million data, which takes about 3 minutes 27 seconds, for example:

5. view the list settings. The default threshold value is exceeded, for example:

6. Try to delete the list and find an error because it exceeds the threshold value, for example:

7. The Management Center modifies the list value, such:

8. It takes 18 minutes and 47 seconds to insert 5 million data records, for example:

9. The task manager used to insert data. The console occupies a large amount of memory;

Summary

For a long time, I thought that the Sharepoint list library contains more than 5000 non-folders, and the performance will decrease linearly. After testing, I found that the efficiency is considerable. When million data is inserted in the test list, the page turning speed of a single page of 1 K items in the list view is less than a second, which can be said to be very fast.

Of course, your data volume reaches the million level, but the data structure is simple and there is no attachment type, which may make the efficiency faster and have certain errors. In the future, we will perform similar tests, share the results for your reference.

SharePoint 2013 list test on Big Data