Improving Performance of Independent Parallel Workbook Calculations

Aspose.Cells Product Family
1
Hello,

I am trying to improve the performance of something that was built using Aspose.Cells. One thing I am noticing is that as parallelism rises from 1-4 workbooks, performance is near constant however above 4 parallel workbooks, performance seems to degrade linearly.

https://docs.google.com/spreadsheets/d/1fX6piFGZjObwr9iLgTT1IPu24cfMP5KoSQbmJ2FO0hI/edit?usp=sharing


I was wondering if there was maybe a thread pool or anything behind the scenes in Aspose that we could play around with increasing.

Regards,

Eric Rini
eric.rini@gmail.com
2

Hi Eric,


Thank you for contacting Aspose support.

I am afraid, we need a lot more information in order to investigate the matter on our side. Please provide the following information/artifacts.

  • Operating system version & architecture
  • Target .NET Framework version
  • Aspose.Cells for .NET version
  • Processor cores of your machine
  • Amount of available RAM
  • A (standalone & executable) demo application showing the problem
  • Samples to be processed with the demo application

That said, Aspose.Cells APIs do not maintain a thread pool of their own so we need to investigate the cause of performance lag on our side in order to assist your further in this regard.