Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #307
| From | Wishmaster <"sysadmin.rock[SINESTO]"@gmail.com> |
|---|---|
| Newsgroups | comp.databases.ms-sqlserver |
| Subject | Re: strange behavior with SP |
| Date | 2011-05-09 14:55 -0400 |
| Organization | Newsgroup.cl News Server |
| Message-ID | <iq9dbd$3s7$1@news.newsgroup.cl> (permalink) |
| References | <ipudmv$agt$1@news.newsgroup.cl> <Xns9EDCF37D8BCC3Yazorman@127.0.0.1> <iq1l96$fbu$1@news.newsgroup.cl> <Xns9EDDF2C9D7FB6Yazorman@127.0.0.1> |
On 06-05-2011 17:52, Erland Sommarskog wrote:
> Wishmaster ("sysadmin.rock[SINESTO]"@gmail.com) writes:
>> what i'm trying to say is there not any result set on my website and no
>> error message as well. But if i run the stored procedure from Mgnt
>> Studio takes arround 3 minutes to produce a result set.
>> I'm going to check your suggestions.
>
> Three minutes is a tad long for a search from a web page. Since the default
> timeout in most client API is 30 seconds, I suspect that you get a timeout.
>
> I have an article on my web site that discusses various strategies
> for these kind of searches, including the one you are using.
>
>
Erland,
This morning it happened again, but we research it about the recompile
option that you suggested and we used it. Now i'm going to track this
particular issue. I will tell you how it goes later.
Thanks,
PD: what is the link of your website?
Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
strange behavior with SP Wishmaster <"sysadmin.rock[SINESTO]"@gmail.com> - 2011-05-05 11:54 -0300
Re: strange behavior with SP Erland Sommarskog <esquel@sommarskog.se> - 2011-05-05 23:56 +0200
Re: strange behavior with SP Wishmaster <"sysadmin.rock[SINESTO]"@gmail.com> - 2011-05-06 17:22 -0300
Re: strange behavior with SP Erland Sommarskog <esquel@sommarskog.se> - 2011-05-06 23:52 +0200
Re: strange behavior with SP Wishmaster <"sysadmin.rock[SINESTO]"@gmail.com> - 2011-05-09 14:55 -0400
Re: strange behavior with SP Henk van den Berg <hvandenberg@xs4all.nl> - 2011-05-09 21:20 +0200
Re: strange behavior with SP Wishmaster <"sysadmin.rock[SINESTO]"@gmail.com> - 2011-05-09 16:45 -0400
Re: strange behavior with SP Erland Sommarskog <esquel@sommarskog.se> - 2011-05-09 23:52 +0200
csiph-web