SharePoint 2013 list test on Big Data

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.