Re: sql query or stored procudre which one is giving best performance in asp.net

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: "Aidy" <aidy@xxxxxxxxxxxxxxxx>
Date: Fri, 12 Jan 2007 09:27:55 -0000

Stored procedures are better for performance. When you create one, SQL
server stores an execution plan with it. When you execute a SQL query
direct the database needs to create the execution plan each time. I think
more up-to-date versions of SQL Server have more advanced caching of these
things, I'm not that sure. SPs are also easier to write (I think) and
debug.

"tulasikumar" <tulasikumar@xxxxxxxxxxxxxxx> wrote in message
news:uXhOyIhNHHA.4376@xxxxxxxxxxxxxxxxxxxxxxx

hi all,
i have one doubt regarding queries and stored procedures.i am doing
asp.net project,i had written both query based retriving and stored
procudures.I want know about which one was giving best performance.and one
more is when i am passinf sql statement or stored procedure to sqlserver
how these to executed internally.
please tell me the answer these queries

thanks in advance
--
Best Regards,
TulasiKumar

Follow-Ups:
- Re: sql query or stored procudre which one is giving best performance in asp.net
  - From: bpd

References:
- sql query or stored procudre which one is giving best performance in asp.net
  - From: tulasikumar

Prev by Date: Re: Html form trouble
Next by Date: Re: Updating the html inside a panel
Previous by thread: sql query or stored procudre which one is giving best performance in asp.net
Next by thread: Re: sql query or stored procudre which one is giving best performance in asp.net
Index(es):
- Date
- Thread

Relevant Pages

Re: Views vs Stored Procedures, whats the difference?
... application, make suire you don't use dynamic sql in the app, instead use ... yourself up to sql injection... ... addage that procs are better because of the execution plan being in cache is ... stored procedures - one last thing, ...
(comp.databases.ms-sqlserver)
Re: SQL query/datetime help: grabbing all results regardless of datetime form
... > I need some help with a SQL query that's intended to grab results for ... > I'm using ASP VB and SQL Server 2000. ... Use stored procedures instead. ... Please reply to the newsgroup. ...
(microsoft.public.inetserver.asp.db)
How do I do Paging through a large dataset via Stored Procedures
... Paging by dynamically altering the SQL Query ... Create stored procedures ... SELECT * FROM STUDENTS ...
(microsoft.public.dotnet.framework.adonet)
Re: Help with Stored Procedure
... I did mean stuff like system stored procedures (even ... build the query, compile it, and optimize it, then, then this is less ... very not easy using dynamic sql. ...
(microsoft.public.sqlserver.programming)
Re: choices regarding where to place code - in the database or middle tier
... Sure, the DBMS is a good place for simple referential integrity constraints, ... to 4 separately-running-but-pipelined stored procedures, ... A typical user would enact a 100 or so business functions per day. ... own stored procedures' by storing the SQL for every business query in the DBMS ...
(comp.lang.java.programmer)