slow sp from web, fast from QA

From: Henok Girma (reply_at_newsgroup.only.thanks)
Date: 06/19/04 

Date: Sat, 19 Jun 2004 01:52:12 -0400

Hello Gurus,
what can cause my stored procedure to run fast from query analyzer, or
access.. however whenever I call the same sp from a web application, it
takes about 20 seconds..

thank you,

Life is sexually transmitted. 

--
Henok Girma
http://www.henok.com

Relevant Pages

  • Re: Is sql server as good as access 97?
    ... Once you really get into using Query Analyzer for writing your ... Transact-SQL and for formulating 'queries' for exporting to your code, ... resulting stored procedure runs in a small fraction of the time it took to ... Unfortunately the database I am converting ...
    (microsoft.public.sqlserver.programming)
  • RE: Differences in execution times for a stored procedure
    ... If OleDb, ... "Vincent Keller" wrote:> I am trying to execute a time-consuming stored procedure in my application. ... > Are there some known performance differences in executing a query directly through Query Analyzer and through ADO.NET? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: "On Error Resume Next" in SQL Server
    ... When you are running your query in query analyzer, ... > would occur would be due to bad user input which does not ... > that my stored procedure will run to the end of the cursor? ...
    (microsoft.public.sqlserver.programming)
  • Re: Output Parameters Return Nothing
    ... >> when I query the output parameters, they return a value of Nothing. ... >> the stored procedure in Query Analyzer, ... >> Bob L. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Exception: The SqlTransaction has completed; it is no longer usabl
    ... > I hv encountered this exception 'The SqlTransaction has completed; ... returning around 9000 rows in a DataSet and back to the app. ... > When that exception is thrown, I tried running the same stored procedure ... > I was thinking if Query Analyzer can return data very quickly... ...
    (microsoft.public.dotnet.framework.adonet)
Loading