Skip to main content
Solved

ArcSDEQuerier - bind variables

  • April 11, 2013
  • 1 reply
  • 18 views
R
I am using ArcSDEQuerier with only an attribute query to fetch geometry for features.

 

The where clause uses an attribute value populated by an earlier SQLCreator transformer:

 

"POLYGON_NUMBER = @Value(POLYGON_NUMBER)".

 

I have noticed that the query running in Oracle uses a hard-coded value rather than a bind variable.  This adversely affects performance.

 

Is there any reason why the ArcSDEQuerier does not use bind variables?

 

Also is there way to alter the SDE connection CURSOR_SHARING session parameter before running the translation so that I can force the use of bind variables? 

 

 

I am using FME 2012 desktop, the Oracle version is 10g and ArcSDE version is 9.3.

 

Best answer by david_r

Hi,

 

 

for what it's worth, the SQLExecutor doesn't bind variables either, so I guess it's by design.

 

 

Which is a pity, both because of performance but it also makes it a little more complicated when you want to pass string values that contain quotes (Oracle specific solution here).

 

 

David
View original
Did this help you find an answer to your question?
<strong>This post is closed to further activity.</strong><br /> It may be a question with a best answer, an implemented idea, or just a post needing no comment.<br /> If you have a follow-up or related question, please <a href="https://community.safe.com/topic/new">post a new question or idea</a>.<br /> If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

david_r
Celebrity
  • david_rCelebrity
  • Best Answer
  • April 11, 2013
Hi,

 

 

for what it's worth, the SQLExecutor doesn't bind variables either, so I guess it's by design.

 

 

Which is a pity, both because of performance but it also makes it a little more complicated when you want to pass string values that contain quotes (Oracle specific solution here).

 

 

David

Helpful Members This Week

Community Stats

31,370
Posts
118,974
Replies
39,000
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.