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 |
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) |
Mark/Karim, no info related to remotely call procedure showed in the file.