Performance issue with simple mail merge using .NET

Aspose.Words Product Family
1

Hi, We are in the process to acquire the Aspose Library Licenses and as part of the process, we are doing POC’s for various features of the product.
As part of MailMerge POC we are doing Simple MailMerge using Aspose words java library.
But we see the execution of MailMerge is taking 3 second for each recipient or customer document.
below is the process we are doing:

  1. We are using Excel Sheet for Mail Merge recipient List
  2. We are using a java process to store the data from excel sheet into map objects
  3. We are looping through each map Object and processing the Mail Merge for each recipient
  4. We are using the same word document for each recipient and we are saving the simple mailmerge output as pdf document for each recipient

We are trying to test the spreadsheet with 55k records. The Excel sheet conversion to map objects takes around 30 seconds of time but it looks like when we execute MailMerge for each recipient in the loop it takes 3 seconds to execute the simple Mailmerge for one recipient and which causing longer processing time for 55k recipient spreadsheet.

This is very important to us to make any purchase decision as out most of the process are processing a bulk sheet of the recipients.

Please let me know if there is any remedy to resolve this issue and improve performance to execute the simple mail merge.

2

@amitbongale

Please note that performance and memory usage all depend on complexity and size of the documents you are generating. While rendering a document to fixed page formats (e.g. PDF), Aspose.Words needs to build two model in the memory – one for document and the other for rendered document.

The process of building layout model is not linear; it may take a minute to render one page and may take a few seconds to render 100 pages. Also, Aspose.Words has to create APS ( Aspose Page Specification ) model in memory and this may again eat some more time for some documents. Rest assured, we’re always working on improving performance; but, rendering will be always running slower than simple saving to flow formats (e.g. DOC/DOCX).

To ensure a timely and accurate response, please attach the following resources here for testing:

  • Your input documents.
  • Please create a standalone console application ( source code without compilation errors ) that helps us to reproduce your problem on our end and attach it here for testing.

As soon as you get these pieces of information ready, we will start investigation into your issue and provide you more information. Thanks for your cooperation.

PS: To attach these resources, please zip and upload them.