I have 2 ASA12 databases running in a same machine and have a remote procedure from database A to database B. It is fine if running Call/ EXECUTE and return result set quickly, but using Select statement, like SELECT * FROM EXT_SP() and takes a minutes. Both calls have same arguments. Thank you for any information

asked 04 Dec '12, 17:29

pLee's gravatar image

pLee
214111220
accept rate: 0%

Mark/Karim, no info related to remotely call procedure showed in the file.

(05 Dec '12, 19:41) pLee

I am not aware of any reason why there would be a difference in performance here. Would you please do the following:

1) restart your server with -o console.out
2) connect and execute "SET TEMPORARY OPTION cis_option=7"
3) execute the CALL statement
4) execute the SELECT statement
5) shut down the server and email me the console.out file

Karim (Karim [dot] Khamis [at] sap.com)

permanent link

answered 05 Dec '12, 09:32

Karim%20Khamis's gravatar image

Karim Khamis
5.7k53870
accept rate: 40%

edited 05 Dec '12, 09:45

Mark%20Culp's gravatar image

Mark Culp
24.9k10141297

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×103

question asked: 04 Dec '12, 17:29

question was seen: 3,018 times

last updated: 05 Dec '12, 19:41