Hi, (sorry for first posting this item in JBossWS forum!)
Moving a production application from jboss 3.0.6 to jboss 3.2.5, we found a critical
issue; the SQL queries execution time were rising from about 160 ms to 1200 ms !
Database server is on a dif. machine and remains the same.
(MS-SLQ server 2000)
For this test we are using jboss's default server configuration for both versions.
We made à simple Benchmark application to test SQL request's performances. (not to
be confused by diff. in application perf. prob.)
Here is the Datasource definition file used:
<?xml version="1.0" encoding="UTF-8"?>
<local-tx-datasource>
<jndi-name>jdbc/DATASOURCENAME</jndi-name>
<connection-url>jdbc:microsoft:sqlserver://dbserver:####;ServerName=dbserver;PortNumber=####;DatabaseName=DBNAME;User=dbuser;Password=dbuserpwd;Selec
tMethod=cursor</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
<user-name>dbuser</user-name>
dbuserpwd
<prepared-statement-cache-size>50</prepared-statement-cache-size>
<min-pool-size>5</min-pool-size>
<max-pool-size>50</max-pool-size>
<idle-timeout-minutes>15</idle-timeout-minutes>
<track-statements>false</track-statements>
</local-tx-datasource>
Regards,
Damien.
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3844892#3844892
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3844892
-------------------------------------------------------
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
