I was reported by a load-test team of one client project.
They said two many function call requested by ArcSOC.exe. and to improve performance of sql query, should modify function call to raw sql statements.
they gave me the function-call sql like SDE.ST_EnvIntersects.
I want to check two things.
- Using function call, is more load on DB, than sql query.
- If yes, How to reduce internal function call?
A. reduce returned features.
- to fetch versioning data , require bigger function call than non-versioning data?
(I see delta tables query in sql scanning)