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

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

Myoung-okYoo — Wed, 22 Oct 2014 00:37:55 GMT

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.

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

VinceAngelo — Wed, 22 Oct 2014 14:38:31 GMT

The SDE.ST_EnvIntersects function is the least-intensive spatial query constraint. There is no raw SQL replacement (unless you disable spatial queries with attribute-first, which would be much more intensive).

Versioned queries are, of course, more intensive than non-versioned queries (due to the UNION ALL join).

- V

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

Myoung-okYoo — Thu, 23 Oct 2014 02:37:07 GMT

Thank you for your response.

We deep concern whether remove versioned data.

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

VinceAngelo — Thu, 23 Oct 2014 13:51:00 GMT

That is certainly your choice, though versioning is the only way to accomplish long transaction editing in Desktop and ArcGIS replication.

- V