Report generation is very slow.
-
Hi,
We bought the latest version of js report server v4.5.0 recently. It takes a long time to generate the report. As our business requires generation of thousands of report on a daily basis, this slowness is really impeding our business.
We found that js report server is taking so much time in writing to report file. Another issue is that when this file exceeds the size of 2GB, js report server is not starting.
Currently we have config of 12 worker threads in config json.
We need help from JS report support team regarding what is the best configuration to speed the report generation.
Thanks,
Ranga
-
Would you be able to send me your workspace export with input data so I can review it and see if there are any opportunities for improvement?
-
Hi,
Thanks for your quick response. Could you please tell me how I can export the workspace?
-
You can find it here
https://jsreport.net/learn/import-export
-
Hi,
I have exported all important folders but size is around 16 MB and could not upload here. Even individual folders export also exceeds your size limit.
I have given below of the output of one consolidated report whose status was success but there is an error loading dhilogo from assets even though it is there, seeing lots of replaced assets in the log, rendering handlebars and time to store the report in the path takes a long time.
info+0Render request 1233 queued for execution and waiting for available worker
info+2836Starting rendering request 1233 (user: dhicrm)
info+0Rendering template { name: pdf, recipe: chrome-pdf, engine: handlebars, preview: false }
debug+2Inline data specified.
debug+192Base url not specified, skipping its injection.
debug+184Replaced assets ["../../../../assets/dhilogo.png","signature (2).png","dhi (2).png"]
debug+0Rendering engine handlebars
debug+606Replaced assets ["../../../../assets/service_icons/Court Record Check.png","dhi-report-bg.png"]
debug+4Executing recipe chrome-pdf
debug+5Converting with chrome Chrome/138.0.7204.94 using chrome-pool strategy
debug+76Page request: GET (document) file:///tmp/jsreport/autocleanup/5569773f-f001-4137-9224-9886fb67f19e-chrome-pdf.html
debug+45Page request finished: GET (document) 200 file:///tmp/jsreport/autocleanup/5569773f-f001-4137-9224-9886fb67f19e-chrome-pdf.html
debug+47Page request: GET (image) data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAxkAAAE6CAYAAAB6RJ9OAAABfWlDQ1BJQ0MgUHJvZmlsZQAAeJx1kc...
debug+1Page request finished: GET (image) 200 data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAxkAAAE6CAYAAAB6RJ9OAAABfWlDQ1BJQ0MgUHJvZmlsZQAAeJx1kc...
debug+0Page request: GET (image) data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAk8AAABbCAYAAABqH2HKAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjw...
debug+1Page request finished: GET (image) 200 data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAk8AAABbCAYAAABqH2HKAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjw...
debug+0Page request: GET (image) data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAIYAAACGCAIAAACXG2XGAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjw...
debug+0Page request finished: GET (image) 200 data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAIYAAACGCAIAAACXG2XGAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjw...
debug+1Page request: GET (image) data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAQQAAACzCAYAAABvsGJzAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjw...
debug+0Page request finished: GET (image) 200 data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAQQAAACzCAYAAABvsGJzAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjw...
debug+0Page request: GET (image) data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAGgAAABgCAYAAADxTzfMAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjw...
debug+1Page request finished: GET (image) 200 data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAGgAAABgCAYAAADxTzfMAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjw...
debug+8Page request: GET (image) data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAACbEAAAt/CAYAAADZgUl+AAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAA...
debug+5Page request finished: GET (image) 200 data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAACbEAAAt/CAYAAADZgUl+AAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAA...
debug+1Page request: GET (font) file:///assets/font-awesome/webfonts/fa-solid-900.woff2
debug+9Page request: GET (font) file:///assets/font-awesome/webfonts/fa-solid-900.woff
warn+0Page request failed: GET (font) file:///assets/font-awesome/webfonts/fa-solid-900.woff2, failure: net::ERR_FILE_NOT_FOUND
debug+0(console:error) Failed to load resource: net::ERR_FILE_NOT_FOUND
warn+2Page request failed: GET (font) file:///assets/font-awesome/webfonts/fa-solid-900.woff, failure: net::ERR_FILE_NOT_FOUND
debug+0(console:error) Failed to load resource: net::ERR_FILE_NOT_FOUND
debug+0Page request: GET (font) file:///assets/font-awesome/webfonts/fa-solid-900.ttf
warn+2Page request failed: GET (font) file:///assets/font-awesome/webfonts/fa-solid-900.ttf, failure: net::ERR_FILE_NOT_FOUND
debug+0(console:error) Failed to load resource: net::ERR_FILE_NOT_FOUND
debug+105Running chrome with params {"printBackground":true,"format":"Letter","timeout":356171,"margin":{}}
info+258pdf-utils is starting pdf processing
debug+1pdf-utils detected 1 pdf operation(s) to process
debug+11pdf-utils running pdf operation merge
info+1Starting rendering (child) request (user: dhicrm)
info+1Rendering template { name: header-footer, recipe: chrome-pdf, engine: handlebars, preview: false }
debug+1Inline data specified.
debug+3Base url not specified, skipping its injection.
debug+8Replaced assets ["../../../../assets/dhilogo.png","header.jpg","footer.jpg"]
debug+1Rendering engine handlebars
debug+20Executing recipe chrome-pdf
debug+3Converting with chrome Chrome/138.0.7204.94 using chrome-pool strategy
debug+66Page request: GET (document) file:///tmp/jsreport/autocleanup/940d74e1-a9a9-4eec-8fc4-526d8c936faf-chrome-pdf.html
debug+24Page request finished: GET (document) 200 file:///tmp/jsreport/autocleanup/940d74e1-a9a9-4eec-8fc4-526d8c936faf-chrome-pdf.html
debug+10Page request: GET (image) data:image/jpeg;base64,/9j/4AAQSkZJRgABAgEAAAAAAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0aH...
debug+1Page request finished: GET (image) 200 data:image/jpeg;base64,/9j/4AAQSkZJRgABAgEAAAAAAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0aH...
debug+0Page request: GET (image) data:image/jpeg;base64,/9j/4AAQSkZJRgABAgEAAAAAAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0aH...
debug+13Page request finished: GET (image) 200 data:image/jpeg;base64,/9j/4AAQSkZJRgABAgEAAAAAAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0aH...
debug+2Running chrome with params {"timeout":355559,"margin":{},"printBackground":true}
debug+50Skipping storing report.
info+0Rendering (child) request finished in 4608 ms
debug+28pdf-utils postprocess start
debug+27pdf-utils postprocess end
info+2pdf-utils pdf processing was finished
debug+425Report stored as reports/dhi-crm/base-templates/consolidate/pdf/hrclXU8Li0n0TvTb.pdf
info+0Rendering request 1233 finished in 5090 msThanks in advance for your help.
Ranga
-
this is the folder structure. which folder do you need to get exported?
-
You can upload the export to your personal onedrive/dropbox/google drive... and share the link here.
I need to be able to run your template with the data so I can fiddle with it and check possible improvements.