Database Test Performance with custom connection properties

Question

Hi Community,

I would like to test the positive impact of applying this kb in a data-center environment

https://confluence.atlassian.com/jirakb/using-the-default-oracle-jdbc-fetch-size-may-lead-to-performance-issues-in-jira-1014278793.html

I'm planing to use this test benchmark but I did not find a way to pass the connection property in the JDBC URL in a Oracle database.

I can successfully run below command but I would like to include the connection property defaultRowPrefetch=200 to check if will it improve the database connection.

java -cp ./atlassian-log-analysis-0.1.1.jar:/opt/jira/atlassian-jira-software-7.13.5-standalone/lib/ojdbc8.jar \ 
com.atlassian.util.benchmark.JIRASQLPerformance \
username password 'jdbc:oracle:thin:@//databaseaddress:1521/jiradb' \
oracle.jdbc.OracleDriver \
> current.txt

Thanks in advance

Gonchik Tsymzhitov · Accepted Answer

Hi!

Let's provide a PR to extend the functionality

https://github.com/AUGSpb/atlassian-support-benchmark