February 10, 2006 at 12:50 pm
Hello, I wonder if I want to run a stored procedure on a remote server, I can either run it through QA, or, by using osql/isql command.
Which is faster?
My computer is very slow, running through QA takes me 3 hours, but running directly from the server takes only 20 minutes. While understand my machine config is not that powerful than the server, I thought using QA to log in server and run the sp will be just like directly run on the server, but not.
So I came across the idea to use osql/isql, will running osql/isql remotely be just like running on the server?
BTW, regarding to the performance, what's the difference between osql and isql?
Thanks.
February 10, 2006 at 12:57 pm
Does the stored prcoedure in question return a resultset ?
If yes, you have to account for network bandwidth in getting that resultset back to QA, then QA's memory requirements in getting it into the display grid.
Also, some of the SET options that are on/off by default in the QA connection may be different, and some of these can impact performance.
February 13, 2006 at 4:49 am
Returning result set makes a lot of difference.
If i understand correctly... Once request is reached to SQL Server it will process in same time (assuming same load)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply