>How do you know it's not working ? Poor performance could be a vast number of >things.
Hi Tom, You're right to suspect that I don't have any direct evidence for this ;-) I'm basing my suspicion on the fact that I see the following in the database logs: Oct 2 08:55:56 db_server xinetd[2232]: START: gds_db pid=12168 from=web_server Oct 2 08:55:56 db_server xinetd[2232]: START: gds_db pid=12169 from=web_server Oct 2 08:55:56 db_server xinetd[2232]: START: gds_db pid=12170 from=web_server Oct 2 08:55:56 db_server xinetd[2232]: START: gds_db pid=12171 from=web_server Oct 2 08:55:56 db_server xinetd[2232]: START: gds_db pid=12172 from=web_server Oct 2 08:55:56 db_server xinetd[2232]: START: gds_db pid=12173 from=web_server Oct 2 08:55:56 db_server xinetd[2232]: START: gds_db pid=12174 from=web_server ... etc. about six entries per second. As I said before we have a CF7 server as well which only appears in this log every few minutes. These entries only appear when I start the CF instance on the web server machine and disappear when it is stopped. Also, the CF8 server has approximately 90 connections to the DB at any one point where as the CF7 server has 15. It is possible to enable logging on the DB driver so I'll turn that on and take a look. >Some databases (maybe FireBird) do actively drop idling connections, in >certain circumstances. Or if the network drops out, that will do it too. Thanks again Tom. I'm quite happy to accept that the DB driver will need to be looked at again, but I was particularly interested to hear if this had been noticed elsewhere. I suspect not. Regards, Simon -- [EMAIL PROTECTED] Applications Development Manager Warwick Business School ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289894 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
