AnsweredAssumed Answered

About  Function call of ArcSDE, How to reduce function-call counts of Geodatabase SQL?

Question asked by moyooesrikr-esridist Employee on Oct 21, 2014
Latest reply on Oct 23, 2014 by vangelo-esristaff

Hi~,

 

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)

 

Thanks.

Outcomes