query runing slow

  • Thread starter Thread starter vicky
  • Start date Start date
V

vicky

I have a query which runs under 15 sec. through query analyzer. But when
same query is getting executed by .net console application, using ado.net,
it takes 10-15 min. What can be the problem?
 
Are you sure that is just the query running time, or is other processing
taking place as well.

Also, is there any thing else going on, transactions, etc?
 
Thanks marina,
No its query time only, because i can see SPID of .net app in sysprocess
table in runnable state for long time.
There is no transaction going on.
Moreever why query analyzer is executing same query faster from the same
client machine.

Thanks
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Differences in execution times for a stored procedure 2
Query on SQL Server is fast, while Access is crawling 2
sql timeout from web application problem (works good in sql server 2
ADO.NET Query Execution time is 10 times slower than via Query Analyzer 11
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Design Question: Form controls run queries at X interval 2
Stored Procedure query slow in debug configuration. 3
Query 10 times slower (and results reordered!) from ASP.NET page than console app. 15

Back
Top