SQL Server Performance

Searches timing out

Discussion in 'Please Tell Us What You Think' started by bytehd, Jun 3, 2007.

  1. bytehd New Member

    June 3, 7pm EST

    Microsoft OLE DB Provider for SQL Server error '80040e31'

    Timeout expired

    /forum/search.asp, line 349
  2. judehk New Member

    Yes this is unfortunately quite a common problem on the Snitz forum.<br /><br />I'd recommned using Google to search the forum using the below search term:<br /><br />forum xxx site<img src='/community/emoticons/emotion-7.gif' alt=':s' />ql-server-performance.com<br /><br />replacing xxx with your search query. This should actually give you better results than any Snitz search.<br /><br />
  3. CG2000 New Member

    this is a bad problem for a forum that is focused on databasing...

  4. Madhivanan Moderator

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by judehk</i><br /><br />Yes this is unfortunately quite a common problem on the Snitz forum.<br /><br />I'd recommned using Google to search the forum using the below search term:<br /><br />forum xxx site<img src='/community/emoticons/emotion-7.gif' alt=':s' />ql-server-performance.com<br /><br />replacing xxx with your search query. This should actually give you better results than any Snitz search.<br /><br /><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />This is what exactly I suggest<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
  5. satya Moderator

    CG
    This is not the site problem, it is the proprietary code used by Snitz and nothing much you can do rather than spending lot of time in fine tuning that bit.
    Jude is in process to make it better and soon you might hear such good news.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  6. CG2000 New Member

    So toss Snitz and use another forum software program. The internet is full of PHP MySQL BBS/Forum software packages - some of which are even free, and have tools for migrating. Given the degree of competence on the forum knocking up a custom IIS, ASP, SQL 2005 solution wouldn't take much.
  7. judehk New Member

    Well for an ASP.NET environment we only have one real choice - Community Server (custom coding a forum from scratch would be a huge task - even the official ASP.NET site uses Community Server). There's some great php options out there as you said but I really don't want to mix an ASP.NET site with a php forum.
    Alas, migrating from Snitz to CS is not a snap at all. Also, CS is a good bit of kit but it is intended as a complete website not as a standalone forum to be inserted into another site, so there are really two issues migration and integration (oh and of course the fact that CS comes with zero documentation)
    I have a beta of the migration done - looks fine but there are still a few issues. And I'm working on the integration now, I hope to have this done in several weeks but unfortunately I can't be sure as I don't know the issues till I hit them (again the lack of CS documentation strikes).

    Anyway, just wanted to give you folks some feedback on the progress. I appreciate the patience and that Snitz has passed its sell-by date on this site.
  8. CG2000 New Member

    I appriciate the fact that you are probably doing this as a side project. CS is an interesting choice, I was bitten trying to implement a MS Helpdesk application for a client during it's early development release with a lack of documentation and a limited SDK. Microsoft products can be a bit rough to work with when they are in their early stages. It makes sense to stick to a IIS/ASP.Net/SQL enviroment, less complex. But going to a Apache/PHP/MySQL might be an easier migration path. You might get caught in some annoying data conditioning and user account migration issues. A lot of the Apache/PHP/MySQL solutions aren't very robust but they do make switching between packages easier.<br /><br />Good Luck!<br /><br />I look forward to when I can do a query on a site dedicated to databasing...<br /><br /><img src='/community/emoticons/emotion-5.gif' alt=';-)' />

Share This Page