@Cutter: thanks for the info - that's what I would have expected, so good to
know.
@Jochem:
The config for the Spring provider looks like this:
<bean id="collegeDataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property
name="driverClassName"><value>net.sourceforge.jtds.jdbc.Driver</value></prop
erty>
<property
name="url"><value>jdbc:jtds:sqlserver://xxx.xxx.xxx.xxx:1433/college_test</v
alue></property>
<property name="username"><value>xxx</value></property>
<property name="password"><value>xxx</value></property>
</bean>
And for the CF datasource:
<bean id="CFDataSourceService"
class="coldfusion.server.ServiceFactory"
factory-method="getDataSourceService"/>
<bean id="collegeDataSource" factory-bean="CFDataSourceService"
factory-method="getDatasource">
<constructor-arg type="java.lang.String" value="xxx"/>
</bean>
And then I go into the CF admin and turn "maintain connections" on or off.
This is a clean CF8.01 developer install, so pool settings would be default
(but not sure where to check that).
Jaime
> -----Original Message-----
> From: Jochem van Dieten [mailto:[email protected]]
> Sent: Wednesday, 4 February 2009 5:00 AM
> To: cf-talk
> Subject: Re: Connection pooling - why bother?
>
>
> On Fri, Jan 30, 2009 at 10:12 AM, Jaime Metcher wrote:
> > Just wondering if anyone has benchmarked CF's connection
> pooling. I'm
> > getting results suggesting that turning on "maintain
> connections" does
> > basically nothing for performance, and that using an alternative
> > unpooled connection provider (in this case Spring's
> > DriverManagerDataSource with
> > jTDS) is way faster.
>
> > However, testing on CF8.01 with 10 simultaneous requests,
> I'm getting
> > about 50% better throughput with Spring's setup than going
> via CF's datasources.
>
> How did you configure both? Can you provide full JDBC URLs
> and pool settings?
>
> Jochem
>
>
> --
>
> Jochem van Dieten
> http://jochem.vandieten.net/
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318793
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
