Hi All,

I am having an SQL query (mentioned below). When I am running this query it is taking 90 min to retrieve all records (approx 1 million records).

Fetching data from 5 tables using inner join in cache. Relative cost displaying 10 million

I wan to confirm How this query can be optimized

0 12
0 160
Matthias Röttger · Jan 26
Line Separator

Hello all,
I am facing a little issue with line separators. I export classes with $SYSTEM.OBJ.Export to the file system, but I'm on a Linux (docker) environment and he uses LF.

Is it somehow possible to change the line separator for the export or in general?

Thanks in advance!

Bests, Matthias

0 5
0 79

I have code hier and trying to view diacrit character

Class Test.REST.Services Extends EnsLib.REST.Service

Parameter ADAPTER = "EnsLib.HTTP.InboundAdapter";

Parameter EnsServicePrefix = "^TEST";

XData UrlMap
<Route Url="/dio/:Resource" Method="GET" Call="getDio" />

0 1
0 92