Worst performance for VM collection api response for VM's having computed properties

[vissharm]

Hi,

I am really stuck with improving performance for the cases like apply sorting (rest api call with sort params) on those properties on the VM collection which have some logic/dependency on other properties for computation.

For example...

Call api/v1/testReport?sortBy=pathColumn&order=asc

Now suppose we are returning VMCollection which have VM class objects

Now in the VM class, I have pathColumn property which is returning value based on some logic and loop...

Creating this VM collection on the fly from static file or database doesn't take much time but for VM's having such property and sort operations on these make the response too slow...

I am avoiding caching as we already used lot of caching which keep on growing memory requirement on cloud and add cost... caching will happen for per user so it will grow drastically....

Another approach to save these computed properties in the model/file/database, which would required more work for all the computed properties... looking for some generic approach for such cases.

looking for help...