ahh thank you. we had problems with low data source timeouts a little while back, we might try shortening them up again.
----- Original Message ----- From: "Robert Shubert" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 14, 2004 12:39 PM Subject: RE: Witango-Talk: data sources > You are correct that it opens new connections when all existing > connections are busy. The trick is defining 'busy'. It can be the case, > due to the internal threading of Witango, that more or less connections > will be opened then you might guess. For the most part, a constantly hit > site will always have 1 open connection. As simultaneity increases so > will the number of connections. You can spot problems with databases by > seeing if the number of connections equals the number of allowable > threads, or is generally very high. Even my busiest sites typically have > only 4-5 connections open. > > In the past I've advocated lower timeouts to keep the connection pool to > a minimum and to often refresh connections. I have recently, however, > found that database connections are more reliable with the newer MDAC > drivers, and now support a 15 minute timer. > > My systems are all Win2k, W5-065 and MSSQL2K > > Robert > > > > -----Original Message----- > From: Alan Wolfe [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 14, 2004 1:10 PM > To: [EMAIL PROTECTED] > Subject: Witango-Talk: data sources > > hello, > > I was wondering, when you do a <@DATASOURCESTATUS> and it lists > different > data sources along with the user ref they were spawned under (right?), i > see > multiple datasources but not a datasource for each user ref who used > that > datasource. Meaning...in the course of the day if we have 150 users who > deffinately accessed one of the databases, there arent 150 open > datasources > of that database, but there might be anywhere between 5 and 10 of em > open. > > what im wondering is why sometimes will it open a new data source and > other > times for a person and other times it wont? > > Does it only open a new data source when all current data sources from > the > requested source are busy? Or is there some other rule? > > Just trying to better understand. > > Thank you! > Alan > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
