Re: Witango-Talk: Server Threading Upgrade

[Rick Sanders]

Hi Cory,   All I can say is that With Enterprises is well aware of the threading issues with the Tango server. I don't want to steal their thunder when they release the list of new features, so all I can say is stay tuned because it'll be woth the wait!   In the mean time, here are a few things you can try:   1. Keep the database optimized. Do a compact & repair, or file rebuild often. It's kind of like de-fragmenting your HD. 2. Try increasing the THREADPOOL Size setting in the Tango config from the default 20 to 50. 3. Try decreasing the EXECUTION Timeout setting if the queries are bringing back errors, or try increasing this setting if you have a vaery large database, or you are using MS Access or Filemaker.   Rick Sanders   I am a current user of Tango2000. My primary complaint about the server is the threading performance. This causes the Tango server to hang when there is an overload of traffic, or if the database is overloaded. The latter issue is the primary case. Basically, for one reason or another, a query takes a while to return its results. This, in turn, causes Tango to hang by queuing all requests until the query completes and Tango can serve that particular request.   The Tango server hangs around 2-3 times per week. This usually results in having to bounce the Tango server b/c the wait can be anywhere from 3-10 minutes.   Has anyone heard of plans by Witango to improve server threading? If they have plans to do this, I would be very interested in upgrading to their server.   For information concerning our environment, we are running a very complex order entry system for about 100 internal users. We have 2 Tango servers running on 2 Win2000 server boxes.   Thanks, Cory Whitsett