Large Data volume on HANA - XS
I have a requirement to be able to show large data volumes on a UI5 application that I am building on HANA. The requirement is to be able to show like 20-30 million rows of data in a grid (if the need be, not practical, but user can if we wishes to) based on multiple tables in HANA. The product is like a data explorer of the underlying tables being built for a larger process.
We planned to achieve this by using an OModel (server side model) on UI5 and tying the same to a XSOdata service. The XSOdata service is built to expose a calculation view which has a union of multiple tables and a projection on top. We have server side paging enabled by default on the table control in UI5. What that means is that every-time a user scrolls (or does a pagedown), the UI5 control makes a call to the OData service with $top and $skip commands. This takes like 4-6 seconds and gives a bad user experience. The key problem that I see here is not being able to cache the result of my query. Is there a way to cach the result of a query on a calculation view instead of running the view again and again for every $top and $skip? How can I attain some level of state-full behavior in this scenario?