Hibernate version: 2.1.6
I am having a performance issue when I hook in connection pooling using c3p0. When I don't have the connection pooling in I see a performance boost of about 3-4 times faster. I am using JTDS 0.8.1. I was wondering if anyone else is having this issue or if I am doing something wrong in my configuration.
Session session = SessionFactory.createSession( dbEnum );
resultList = session.find( query, params, types );
session.close();
<property name="connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property> <property name="connection.url">jdbc:jtds:sqlserver://PLUTODEV/xxx;user=xxxx;password=xxxx;sendStringParametersAsUnicode=false;TDS=7.0</property> <property name="connection.username">firstlook</property> <property name="connection.password">passw0rd</property> <property name="c3p0.acquire_increment">2</property> <property name="c3p0.idle_test_period">3000</property> <property name="c3p0.max_size">2</property> <property name="c3p0.max_statements">100</property> <property name="c3p0.min_size">2</property> <property name="c3p0.timeout">5000</property>
Name and version of the database you are using: SQLServer 2000
|