Preforming calculations on ASP server or on SQL server

[joelwenzel]

Hi,

I have some calculations I need to do. I can create a stored procedure to do them or I can do them in an asp.net page.

So, which is quicker/more efficient?

 

[jbenson001]

A stored procedure will definately run faster.

Jim

 

[dvannoy]

let sql server do as much work as possible..that's what it does best.

 

[joelwenzel]

I understand that the stored procedure is faster if I need to do multiple select statements,...but, what if i just need one select statment. I then just get the data and manipulate it via asp.net (or in the stored procedure via a cursor). Would the stored procedure still be faster in this case?

 

[ca8msm]

Why don't you test both ways and you'll see which is faster?


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[joelwenzel]

well, I'm just looking for a general rule...but maybe I will give it a shot. I don't have anything specific to test at the moment though.

 

[dvannoy]

if your selecting records to say fill a ddl and theres only 20 or so records then yaa, I would write my code in the code behind. that's just me. but,,,I use SP's whenevr I can. why bogg down the front end when the server can do the work for you? you may not even notice the slow down but SP's are still the way to go.