Server side caching

[Former Member]

Hi all,

I have a requirement to fech thousands of record from functional module to gateway, this leads to performance issue in Gateway so my idea is to implement SQRC and Delta query. I am not able to find the implementation examples.

I feel SQRC or Delta query would be the option to do server side caching or is there any other method where i can achieve this functionality?

Please help me with these requirements.

Thank you and Regards,

Sumanth.B.S

[AshwinDutt · Accepted solution]

Hello Sumanth,

Little more info on what kind of data you would be fetching will help to find the suitable option to get data from back-end.

However i will try to share some points here,

Firstly i would suggest to try to see if there is any room for you to filter out the data when getting from the back end it self based on some filter parameters. So that service would be light with only required result set and response time would be good.

If at all for some reason above is not possible then you can go for limiting the data fetch in the back end itself and return limited data to front end. Then on demand you can get next set of records again in the next service call.

Please have a look ->

Soft State would be used when you want to load larger amount of data in the initial request only. So that already loaded data can be re-used when needed for the next subsequent requests.

I am not aware of the kind of data you would like to fetch with delta query implementation. This would be used to get information of the items which are modified since the last call made.

However you can see the details here ->

Based on the requirement and kind of data you fetch, you can choose the suitable mechanism for the data retrieval.

Regards,

Ashwin