I am getting timeouts whenever I use the search page: http://sql-server-performance.com/forum/search.asp Microsoft OLE DB Provider for SQL Server error '80040e31' Timeout expired /forum/search.asp, line 349 www.elsasoft.org
I guess that is a known problem with Snitz forum package when your search criteria isn't specific enough, so that many rows will be returned. -- Frank Kalis Moderator Microsoft SQL Server MVP Webmaster:http://www.insidesql.de
Not sure on that one I'm afraid Jezemine. You might actually try using the main site search fucntion and adding the keyword 'forum' to your search as this would effectively search the forum as well. The site search now uses Google's search which has pretty much got the whole of the site in its index. You might also have experienced this as I am doing a bit of site maintenance (ie bug chasing!) and I am having to restart the server now and again.
my criteria was not that broad actually. I was searching for "generate scripts" with a date filter of "since 7 days ago". all other criteria I left with the defaults. I can't imagine that more than a few results would come back with this criteria. I just tried it again, still get the timeout. Jude: if you want to fix this, it might be useful to see what query is being executed by the search page, and make sure the proper indexes are on the relevant tables. www.elsasoft.org
Hm, yes, one might indeed expect such a query to return only a handful of rows. <br />Hopefully Snitz will be replaced very soon. [<img src='/community/emoticons/emotion-1.gif' alt='' />]<br /><br />--<br />Frank Kalis<br />Moderator<br />Microsoft SQL Server MVP<br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>
