How to increase database speed

na1s November 11, 2013

What is wrong with this configuration?

It generates a lot of validation queries.

Also I've tested with testOnBorrow=true, testOnReturn=false, but it doesn't change anything.

<jira-database-config>
<name>defaultDS</name>

  <delegator-name>default</delegator-name>

  <database-type>mssql</database-type>

  <schema-name>jiraschema</schema-name>

  <jdbc-datasource>

    <url>jdbc:jtds:server</url>

    <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>

    <username>jira</username>

    <password>jirapassword</password>

    <validation-query>select 1</validation-query>

  </jdbc-datasource>

</jira-database-config>

1 answer

0 votes
Renjith Pillai
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 11, 2013

I didn't quite get the question. The validation query is meant to be executed continously to validate the db connectivity. Are you facing any application performance issue?

Sergey Svishchev
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 26, 2014

validation query is meant to protect the app from database restarts, but if the database is reasonably stable, constant validations are somewhat pointless

Suggest an answer

Log in or Sign up to answer