Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Site Related Discussions
 timeout errors

Author  Topic 

harshal_in
Aged Yak Warrior

633 Posts

Posted - 2004-02-25 : 04:55:51
hi
has anyone noticed timeout errors in search recently ? ?
I had timeout errors on search a couple of times.
harsh.


He is a fool for five minutes who asks , but who does not ask remains a fool for life!

mohdowais
Sheikh of Yak Knowledge

1456 Posts

Posted - 2004-02-25 : 09:02:54
Yeah me too

OS
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2004-02-25 : 11:37:37
2003 was a pretty active year...

did you try limiting the search criteria...

it's probably scanning the data pages....



Brett

8-)
Go to Top of Page

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2004-02-25 : 14:22:43
I have had timeouts if I'm searching too large of a range, as Brett has suggested. But since Graz upgraded the Snitz code a while back, it doesn't time out as quickly as it used to. And if I remember correctly, Graz is prohibited from adding Full-Text search which would be nice to have.

--------------------------------------------------------------
Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url]
Go to Top of Page

harshal_in
Aged Yak Warrior

633 Posts

Posted - 2004-02-26 : 01:29:05
I have never tried to limit the searches, as the more threads u read the more knowledge u gain. :)


He is a fool for five minutes who asks , but who does not ask remains a fool for life!
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-02-26 : 12:46:21
quote:
Originally posted by harshal_in

I have never tried to limit the searches, as the more threads u read the more knowledge u gain. :)




True, but you won't get the timeout error when you narrow down your results. Also searching on everything slows the site down for everyone else. It sometimes is necessary, but try to limit the search a little, even if you have to search forum by forum.

Tara
Go to Top of Page
   

- Advertisement -