cancel
Showing results for 
Search instead for 
Did you mean: 

Spatial Analysis - in SAP HANA XSJS

former_member187794
Participant
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

thomas_jung
Developer Advocate
Developer Advocate
0 Kudos

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.

former_member187794
Participant
0 Kudos

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

thomas_jung
Developer Advocate
Developer Advocate
0 Kudos

First question would be why is the response time calling via Stored Procedure not good?

XSDS does not support spatial SQL Functions. Nor would I really recommend the use of XSDS as it isn't supported forward into XSA. Once you migrate you will have to rewrite/redesign your application.

former_member187794
Participant
0 Kudos

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

thomas_jung
Developer Advocate
Developer Advocate
0 Kudos

>We are migrating to XSA, our environment is ready as well. Will the migration assistant does this re-design?

No