How to increase database speed

[reltio-coderabbit]

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>

[Renjith Pillai]

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]

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