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
