1 Reply Latest reply on Aug 12, 2004 5:45 AM by Damien SALVIA

    Dramatic SQL response time moving from jboss 3.0.6 to 3.2.5

    Damien SALVIA Newbie

      Hi,

      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 raising 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.