Queries taking long time

By Shashank Diwan on 24 Nov 2015
Team,

Few days back we were facing performance issues in fetching the data from the database for some complex queries. I searched the forum and found the below discussion.

http://www.outsystems.com/forums/discussion/15702/tip-performance-of-query-in-outsystems-platform-slower-than-running-in-database/

What i found is that

OutSystems platform uses Case Insensitive and Accent Insensitive behavior by default. This means we set the NLS_COMP and NLS_SORT variables as:
- NLS_COMP: LINGUISTIC
- NLS_SORT: BINARY_AI

Which is actually causing the slowness. I just did a quick test and before executing an advance query i updated the session variable to
- NLS_COMP: BINARY
- NLS_SORT: BINARY

This really helped me and the queries and returning data way faster than earlier. So far i have not seen any negative impact of it, however i would like to know if it has any impact in futureor it is not a right way.

Shashank... 

J.25 Nov 2015
Why is this in the Ideas section?

Kilian Hekhuis27 Nov 2015
Indeed. This doesn't belong here.
Curt Raddatz3 Dec 2015
Can someone please delete this.