How to optimize multiple json call in a table to load the page faster?

[srikanta sahoo]

On a single page, I have a table where each cell content a rest service result display using JSON table and table transformer macro. I gave wit 48 call takes around 5 minutes. Is thee a way to optimize the performance that takes less time. Like add a button the cell and once the user clicks the button, then  only we call the macro to display the result.

Attached the current view of the page.

[Florian]

It‘s hard to tell without knowing the underlying details. 48 calls does not look that much in my opinion.

Ask yourself the following questions:

- Is it possible that the answers are too big so that to much data needs to be transferred over the line?

- Do the calls cause some database request with a missing index so that the answers are small but it takes a long time to find the needle in the haystack?

- Can you make a single request that gives you all answers at once and then iterate over the data to fill you table?

- Is it possible to cache the data? Can you provide a server that periodically pulls the source system once an hour and then stores the results for your overview.