Skip to Content
0

Default sorting order in xsodata on HANA XS

Apr 27 at 07:28 AM

72

avatar image

Hi Experts,

I am using a UI5 app that uses xsodata to fetch data from HANA XS calculation views.

When analyzing the performance, I found that the queries being executed have a default ORDER BY clause, which lists all the properties from the SELECT clause. This happens even when we do not specify the sort order from the UI.

Running the same query without the ORDER BY clause improves the performance significantly.

Is there any way in which we can prevent the default ORDER BY clause from being added? Any configuration on HANA, a property on the xsodata file perhaps?

I did take a look at the syntax for xsodata here:

https://help.sap.com/viewer/b3d0daf2a98e49ada00bf31b7ca7a42e/2.0.02/en-US/73a801f25cbf425994f22b06d3850591.html

Couldn't find anything that helps.

Any help is much appreciated.

Thank you.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers