In article <6oQAc.1690$Fq2.430@bignews1.bellsouth.net>, "Henok Girma" <reply@newsgroup.only.thanks> wrote:
>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,
Are you using it to build a html table?
The table can't be displayed until the last record is returned and the end
table is reached. That can make the SQL call SEEM to be the culprit.
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: 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)
ADO vs Query Analyzer Performance -- Its not parameter sniffing ... Immediately calling the same stored procedure WITH SAME PARAMETERS from ...Query Analyzer returns the results almost immediately. ... Analyzer call returned very quickly (40 seconds from app,... ADO/SQLOLEDB interaction with SQL Server is different than Query Analyzer. ... (microsoft.public.data.ado)
