A datasourcetimeout of 15-60 minutes is acceptable. All this means is that during times of no/lower activity unused connections will be closed to free up resources.
Each ODBC connection consumes memory (about ½ MB I think), todays servers have no problems juggling 10s or even 100s of them. As I write this there are over 200 connections between my Witango services and my SQL server. The nice thing is that if Witango needs to ramp-up to 20-30 connections to service some peak traffic, most of them will timeout during low traffic. Refreshing ODBC connections can be healthy as well. Especially if you have a problem with your SQL server or network, Witango will need to kill off all active connections and make new ones. For you second question, use @HTTPATTRIBUTE to look for these bots at the top of your TAFs and send back a handmade 404 error. Robert _____ From: Ted Wolfley [mailto:[EMAIL PROTECTED] Sent: Monday, September 15, 2008 11:05 AM To: [email protected] Subject: Witango-Talk: datasource timeout Hi, 2 questions: Question 1: On our win2003 box running Witango 5.5, we noticed we have DATASOURCELIFE=1440, a carry over from when we used to run RTango2000 and Oterro ODBC. Has any one run into any problems running the datasourcelife at its default of 30? Our website is getting hit constantly by bots and wondering if lowering the datasourcelife would increase proformance. Queston 2: Related to question 1, in the iis logs, there are a lot of entries that have lwp-trivial/1.41 or LWP::Simple/5.805. Does anyone have a recommendation on how to handle them. They are hitting the site about every 3 seconds. Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] <http://www.ogdengroup.com> www.ogdengroup.com ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
