How much can a Stored Procedure increase performance ???

[Robert Liberman]

Hi,

I am writing an ASP based application that creates a dynamic querry and then
executes it and displays results. I was thinking about writing a stored procedure to increase performance. How much can the SP help me boost querry responce time ???

Thanks for your time,
Robert

[Peter Cwik]

As always there are many factors, but SPs WILL increase speed for the very fact that it is pre-compiled code. It is executed in one place and only the results have to travel across the network. When a query is run there are multiple trips from client to server. How much time will be saved depends on how the SP is written and what state your network is in.

On 9/25/98 10:23:15 AM, Robert Liberman wrote:
> Hi,

I am writing an ASP based application that creates a dynamic querry
> and then
executes it and displays results. I was thinking about writing a
> stored procedure to increase performance. How much can the SP help me boost
> querry responce time ???

Thanks for your time,
Robert