on 04-23-2018 10:51 AM
Hi Friends
I am trying to understand, if we can use ST_POINT, ST_DISTANCE spatial analysis functions directly in XSJS (via CDS)
Thanks for your inputs
Regards
Giri
What do you mean directly in XSJS via CDS? Do you mean XSJS or CDS? From XSJS you can issue SQL statements and use such functions within this SQL.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Thomas, for the response.
We have achieved this by putting the logic in an Stored Proc. But the response time is not that great. So we thought of using/calling these function (ST_POINT & ST_DISTANCE) from XSJS.
As we were using XSDS for all the interactions with HANA, which is much faster than executing the SQL statements, from XSJS. Can this be possible using XSDS? Thank you
Regards
Giri
We are not just using this logic, but there are few other calculations in the SP. The response time is around 2 seconds, But we are looking for a response below 1 second.
So far, I am in a understanding that, XSDS will give us faster responses than calling a SP/Calc view from XSJS. Hence I am planning to pull the logic from SPs and achieve that in XSJS using XSDS libraries.
In fact we are using XSDS to pull the data from HANA CDS Tables, for all the existing XSJS services. (These tables are populated via SPs which calls the Calc views)
We are migrating to XSA, our environment is ready as well. Will the migration assistant does this re-design?
Thanks for your response
Regards
Giri
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.