Performance Issue: workbook.SaveDocument Slow on Linux Compared to Windows (.NET 8, DevExpress v23.1) - Stack Overflow

admin2025-04-16  4

Description:

Hi Team, I am facing a performance issue while saving a workbook using workbook.SaveDocument on Linux. The same operation runs significantly faster on Windows.

Issue Details:

I am using .NET 8 and DevExpress v23.1 to create and save a workbook. Below is the execution time comparison:

  • Windows (Ryzen 7, 8 Core, 32 GB RAM)30-35 seconds
  • Linux (Ryzen 9 (Host), 4 Core, 16 GB RAM)80-90 seconds

Upon debugging, I found that the major slowdown occurs in the workbook.SaveDocument method on Linux, where it takes 70-80 seconds out of 80-90 seconds total execution time.

Configuration Details:

  • .NET Target: .NET 8
  • DevExpress Version: v23.1
  • Windows Machine: 32 GB RAM, Ryzen 7, 8 Core
  • Linux Machine: 16 GB RAM, Ryzen 9 (Host), 4 Core
  • Linux (Upgraded Config for Testing): 32 GB RAM, 12 Core

Experiments & Findings:

  1. Tried using FileStream instead of MemoryStream – No performance improvement observed.
  2. Increased RAM on Linux to 32 GB and CPU cores to 12 – No impact on performance.
  3. Observed that workbook.SaveDocument is the bottleneck – It takes 70-80 seconds out of 80-90 seconds on Linux.

Replication Steps:

I have created a minimal reproducible example to demonstrate this issue. You can test it by hitting the '/generate-workbook/template' route in the sample app. Also I have attached my Program.cs file for reference.

Sample App Repository: GitHub Link

Questions:

  1. Is this a known issue with DevExpress Spreadsheet on Linux?
  2. Are there any optimizations or workarounds to improve the performance on Linux?
  3. Does DevExpress internally use any Windows-specific optimizations that could be missing on Linux?
  4. Would upgrading to a newer version (if available) help mitigate this issue?
  5. Are there any recommended configurations for improving workbook save performance on Linux?

Any insights or recommendations would be greatly appreciated. Thanks!

转载请注明原文地址:http://anycun.com/QandA/1744768689a87355.html