I figured out that my one of my helper functions is causing the problem. It was a currency formatter that use 'Intl.NumberFormat' . After optimizing the code, the excel generation of 15000 rows now takes 7 seconds(reduced form 16 seconds) which I think is more reasonable.
דן ברק
@דן ברק
Posts made by דן ברק
-
RE: Long duration excel generation
-
RE: Long duration excel generation
I can share the templates. I do I do it ?
-
Long duration excel generation
I am trying to generate excel file of about 15,000 rows and it takes a long time. According to the log file the duration is 16 seconds.
2020-06-28T16:38:09.487Z - info: Rendering request 16375 finished in 16261 ms
2020-06-28T16:38:19.325Z - info: Starting rendering request 16376 (user: null)
2020-06-28T16:38:19.325Z - info: Rendering template { name: list-to-excel-v3, recipe: xlsx, engine: handlebars, preview: false }I am using my own template file with the default xslx confiiguration.
Can you please explain the configuration parameters 'numberOfParsedAddIterations' and 'addBufferSize' ?
I there away to improve the performance ?