You might try reducing the THREADPOOLSIZE. The optimal value is dependant on your hardware configuration and other what other processes are running on your server. A value as low as 5 to 10 may help.
Dave Shelley -----Original Message----- From: Jason Pamental [mailto:[EMAIL PROTECTED] Sent: Friday, October 15, 2004 11:07 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Witango 5 / SQL Server 7 No - it's not. Did you see the problem get better by clearing the cache more frequently? (I'm not caching files or included files, so I'm mainly thinking of the variable caches) On Oct 15, 2004, at 10:49 AM, John McGowan wrote: > We are running this exact same environment in a few locations and the > only problem we have with the Witango service hanging seem to be > directly related to clearing the cache. However it does occasionally > hang when a @purgecache was not done and right now i'm chalking that > up another problem with caching system but on the "loading of the > cache" side of things. The server hangs not directly related to a > @purgecache are few and far between, so not much effort has been put > into debugging them. > > The code isn't doing any @purgecache calls is it? > > /John > > Jason Pamental wrote: > >> Hey everyone- >> >> Anyone out there using Witango 5 connecting to SQL Server 7? One of >> our clients' environment is Windows 2000/SQL Server 7/IIS/Witango 5, >> and we're still having odd issues with threads getting stuck >> seemingly on queries (different ones, not always the same) and then >> hanging the Witango service. Since it's lots of different files, even >> ones that I've rebuilt in Witango 5, I'm wondering if it's an ODBC >> issue. Anyone out there using this combination (ODBC Driver verison >> 3.70.x)? Windows and SQL Server both have the latest service packs >> (issue was there before and after those updates to SP4 on both). >> >> Thanks, >> >> Jason >> >> >> ______________________________________________________________________ >> __ >> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf >> > _______________________________________________________________________ > _ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > -- ____________________________________________________________________ Jason Pamental, President [EMAIL PROTECTED] Bathysphere Digital Media Services, Inc. http://bathyspheredms.com ____________________________________________________________________ Tel: 401.490.6830 Fax: 401.490.6831 ________________________________________ A North American Distributor for Witango (http://www.witango.us) Rapid Web Application Development - XML Execution Engine ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
