on 10-22-2015 5:25 PM
Experts,
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?
I was reading about SQRC - Soft state based Query result Cache. Is it a good idea to use SQRC with SAP HANA to cache the output of a calculation view? This coupled with server side paging and an OModel on UI5 should give a good performance? Thoughts? What would be the sizing impact on SAP Gateway, if in a worst case scenario, 50 users pull 1 Million rows of data (may be 100 columns) which is cached?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.