Hello all,
Its necessary to write stored procedure for select queries that returns multiple records??
Whats performance difference if i run a select query using stored procedure
stead of running query through any server language???
Loading
Hello all,
Its necessary to write stored procedure for select queries that returns multiple records??
Whats performance difference if i run a select query using stored procedure
stead of running query through any server language???
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Therese PunoPosted Jun 9, 2008, 4:29 AM
Base in my exprience stored procedure is much more advantage special client server application
Sudheendra DesaiPosted Jun 4, 2008, 7:43 AM
u can cache the data on application side and use the results, no need of again and again calling strd procs
Bechir BejaouiPosted Jun 3, 2008, 7:12 PM
CREATE PROCEDURE CheckIfUserIsValid
@UID VARCHAR(20),
@PASS VARCHAR(20)
AS
SELECT * FROM MEMBERS WHERE UserId = @UID AND Password = @PASS
RETURN
GO
Vijaya KadiyalaPosted Apr 8, 2008, 11:24 AM
Hi,
If you put your query inside the stored procedure the performance will always be better. The other advantage is It brings up the Loosely coupled dependecy between the front-end application with the database. coz in side the procedure you can have complex logic to write teh data...even if there is a change to the logic the front-end application will not have any impact.
Thanks -- Vj
http://dotnetvj.blogspot.com
Josip MajicPosted Mar 19, 2008, 9:26 AM
Depends on a lot of factors; please describe what is your app trying to acomplish.
Generally, you will get a better performance and security with a stored procedure approach.