Hello Somkead,

Do you want to perform this calculation synchronously or asynchronously? If it's asynchronously then you can use timers where you can do these calculations and then store the calculated values into the entities and then when user browse the application you can show them that data directly from that entities based on their needs.

Thanks,

Sachin

It depends a lot of your logic and use case.

Can you share a screenshot of your logic? Normally this kind of things is related with SQL or long actions not very performant.

If you doing complex calculations with lot of data to show on frontend it might be better to calculate asynchronously and save the results on a new table. Then the screen should query that table for better performance. Otherwise there's a risk of timeout and the user will be unable to see the data. Usually the frontend has a 30 seconds timeout

Hi Somkead Sirichat,

For my understanding best way. Create a timer (back end job) to do complex calculations and Insert into the new table. use the new table to get data and display.

Thanks,

Ramesh

Hi Somkead Sirichat,

I also agree, You should always preprocess the data and save it in the database table then show them to user by fetching from the table. 

Thanks,
Pankaj

Thank you all very much for the good advice

I'm going to try to put the advice into practice.

My background used to do only Traditional Applications.

And being new to low-code with Outsystems, this will be the first project I want to try.

Hi Somkead, 

Just to add a remark to you to display at the Front end the the Date Time which that calculations were done/finished. 

Hope that it helps you