Theo Galanakis wrote:
Does anyone have any insight into how cf manages connection pooling.
I'm connecting to a postgres database with a JDBC J2EE postgres driver.
I assume that cold fusion is maintaining connection pooling and not
using the connection pooling build into the JDBC driver.
I have used a load testing tool to simulate 100 users running a cf page
which basically performs a simple sql. It appears when I run this test
case that postgres has only about 6 connections, and a bottle neck
occurs as hundreds of requests and queuing for these 6 connections.
I have attempted to add maxConnections=100 to the Connection String and
also Select Limit Connections and set Restrict connection to 100 in the
Advanced Settings for the jdbc driver, however neither seem to make a
difference.
What setting on the CF server to you have for max simultaneous
connections? ie. how many CF working threads.
-- geoff
http://www.daemon.com.au/
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
