Question

Performance Issue

2

Hi All, I am having an application in that I have used so many javascript and Html snippet and microflow logics, but my application is very slow even to display a page. Does anyone suggest me to resolve my performance issue in my application. My application is running with only 4 GB RAM but dealing with huge amount of data. Thanks in advance

asked 2021-06-22

Ajitha Deborah D

1 answers

Robert Price · Accepted Answer · 2021-06-22

Are your microflows doing a lot of retrieves? You mentioned you are working with a huge amount of data, so you will need to make sure your retrieves are paginated otherwise you will end up using a lot of memory.

If those microflows are running calculations over the data, then you may want to look at moving them off to a queue or a scheduled event if possible.

Are there any commits in loops that could be refactored out?

One other thing to look at would be to put the ConnectionBus_Retrieve log level up to TRACE, that will show you the database queries being used to build the page. That may help identify slow queries, and any indexes you may need to put on your entities.

Hope these help.