EnovaPoint Lab

 

Moss 2007 vs SharePoint Server 2010.
SharePoint batch document generation.

We have tested batch document generation from 1,000 list items in Moss 2007 and SharePoint Server 2010.

1,000 generated documents in SharePoint from 1,000 list items:

​Moss 2007 ​SharePoint Server 2010
78 seconds 53 seconds
The Sharepoint server' settings:

Microsoft SharePoint Server 2010 virtual machine running on Hyper-V:
Virtual memory 6800MB, 2 virtual processors.

Microsoft Office SharePoint Server 2007
virtual machine running on Hyper-V:
Virtual memory 6800MB, 2 virtual processors.

SQL Server Std 2008 virtual machine running on Hyper-V:
Virtual memory 4072MB, 1 virtual processor.

Hyper-V running on physical server:
Physical Server system

SharePoint batch document generation module takes list item properties and inserts them into .docx document by using Open XML.

SharePoint Batch Document Generator

Press Batch Fill, select a document template you are going to use and wait for a document library to be populated with the generated documents from the list.

Fill performance testing list

After the job is completed you will be redirected to the document library where documents of the selected content type are stored.

Fill Performance testing Library

Now take a look at the last document (number 1,000) opened in Microsoft Word. All list item properties are provided in this document. You can also see the time when this document was generated in seconds (the timer starts upon pressing the Batch Fill button in the SharePoint List).

Autofilled Word document