SQL Server Performance


Discussion in 'Please Tell Us What You Think' started by jezemine, Feb 26, 2007.

  1. jezemine New Member

  2. FrankKalis Moderator

    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
    Microsoft SQL Server MVP
  3. judehk New Member

    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.

  4. jezemine New Member

    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.

  5. FrankKalis Moderator

    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>

Share This Page