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.
Theo
---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/
| ______________________________________________________________________ This email, including attachments, is intended only for the addressee and may be confidential, privileged and subject to copyright. If you have received this email in error, please advise the sender and delete it. If you are not the intended recipient of this email, you must not use, copy or disclose its content to anyone. You must not copy or communicate to others content that is confidential or subject to copyright, unless you have the consent of the content owner. |
