By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,107 Members | 1,221 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,107 IT Pros & Developers. It's quick & easy.

query runing slow

P: n/a
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?
Jun 30 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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?

"vicky" <v@v.com> wrote in message
news:eI**************@TK2MSFTNGP03.phx.gbl...
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?

Jun 30 '06 #2

P: n/a
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

"Marina Levit [MVP]" <so*****@nospam.com> wrote in message
news:uH**************@TK2MSFTNGP04.phx.gbl...
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?

"vicky" <v@v.com> wrote in message
news:eI**************@TK2MSFTNGP03.phx.gbl...
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?


Jun 30 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.