database performance: DIY
Preparing to run the tests yourself:
- Download the test code binary jar and place it
./lib/
- Download the junit/ant test script
- Define the database connection using a simple text file (example here)
in
./build/bin/config/db-connection.properties
- Place the required jar libraries (JNDI, database driver, etc..) in
./lib
Run the tests:
ant -f test.xml junit.dbperf -Ddatabase=db-connection
The test sample data will be placed in the './stats
' directory (see options below to override this location)
Loading the samples into the database:
ant -f test.xml load.data -Ddatabase=db-connection-filename
Generating your own graphs:
ant -f test.xml report.gui -Ddatabase=db-connection-filename
More options, you can specify:
-Dstats.dir=DIRECTORY
: the location of the statistical data collected (defaults to "stats")-Djunit.dir=DIRECTORY
: the location of the junit report and data (defaults to "junit")
Note: you will obviously need to define a new database connection file for each database that you test, but keep the same database
for loading the samples!
Beware: the gui can use up a lot of memory as it loads all the records into memory when first used.