on 04-27-2018 8:28 AM
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:
Couldn't find anything that helps.
Any help is much appreciated.
Thank you.
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
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.