Andy! You rock. That made a huge difference...
### BEFORE NEW ODBC DRIVERS ### siege -b -c200 -t60s http://localhost/ian/index.cfm ** SIEGE 2.66 ** Preparing 200 concurrent users for battle. The server is now under siege... Lifting the server siege... done. Transactions: 4155 hits Availability: 100.00 % Elapsed time: 60.09 secs Data transferred: 137.78 MB Response time: 2.82 secs Transaction rate: 69.15 trans/sec Throughput: 2.29 MB/sec Concurrency: 195.29 Successful transactions: 4155 Failed transactions: 0 Longest transaction: 10.87 Shortest transaction: 0.13 ### AFTER NEW ODBC DRIVERS ### siege -b -c200 -t60s http://localhost/ian/index.cfm ** SIEGE 2.66 ** Preparing 200 concurrent users for battle. The server is now under siege... Lifting the server siege... done. Transactions: 8426 hits Availability: 100.00 % Elapsed time: 60.05 secs Data transferred: 279.40 MB Response time: 1.41 secs Transaction rate: 140.32 trans/sec Throughput: 4.65 MB/sec Concurrency: 197.33 Successful transactions: 8426 Failed transactions: 0 Longest transaction: 3.96 Shortest transaction: 0.06 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Powell Sent: Monday, August 06, 2007 1:27 PM To: [email protected] Subject: Re: [ACFUG Discuss] Tuning CFMX 7 DB Connections The built-in CF datasource is a JDBC connection. I would make sure you're on the latest data direct drivers. That should be task #1. http://kb.adobe.com/selfservice/viewContent.do?externalId=42dcb10a My two cents. Andy On Aug 6, 2007, at 1:17 PM, Fennell, Mark P. wrote: > Does anyone have any references for tuning the data source connections > in CFMX? > We're moving to new hardware after 5 years and we've found the max > capacity for apache (200 connections), cfmx (190 connections) and > oracle 10g (6k connections), but when we put them together performance > drops (70 connections). So, I was wondering if anyone has any > experience with tuning oracle and cfmx? For example, are there known > benefits to configuring an Oracle JDBC connection over using the > built-in CF datasource? > TIA. > mf > > > > mark fennell > athens regional medical center > athens, ga > > > > ------------------------------------------------------------------ > This email is intended only for the named recipient(s). It may > contain information that is proprietary, confidential or otherwise > prohibited from disclosure. If you are not the named addressee, you > are not authorized to read, print, retain, copy or disseminate this > message or any part of it. If you have received this message in > error, please reply immediately by email or telephone me at > 706-475-4357 and delete all copies of the message. > ------------------------------------------------------------------ > > > ------------------------------------------------------------- > Annual Sponsor FigLeaf Software - http://www.figleaf.com > > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists Archive @ > http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by http://www.fusionlink.com > ------------------------------------------------------------- > > > ------------------------------------------------------------- Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com ------------------------------------------------------------- ------------------------------------------------------------- Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
