Difference between CALL/EXECUTE and Select Statement calling remote procedure

[Former Member]

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

[Former Member]

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

[Former Member]

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)