org.apache.derbyTesting.perf.basic.jdbc

Class IndexScanTest

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.apache.derbyTesting.junit.BaseTestCase

org.apache.derbyTesting.junit.BaseJDBCTestCase

org.apache.derbyTesting.junit.JDBCPerfTestCase

org.apache.derbyTesting.perf.basic.jdbc.IndexScanTest

All Implemented Interfaces:

junit.framework.Test

public class IndexScanTest
extends JDBCPerfTestCase

Test the performance of different kinds of index scans. This test was written in order to test the performance impact of the changes made in DERBY-2991.

Field Summary

Fields

Modifier and Type	Field and Description
private java.sql.PreparedStatement	preparedStmt The prepared statement for the SQL expression that we want to test.

Fields inherited from class org.apache.derbyTesting.junit.BaseTestCase

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Modifier	Constructor and Description
private	IndexScanTest(java.lang.String name, int iterations, int repeats) Create an instance of the test.

Method Summary

Modifier and Type	Method and Description
void	decimal10columns() Test the performance of an index scan on a compound index on ten DECIMAL(10,10) columns.
void	decimal1column() Test the performance of an index scan on a DECIMAL(10,10) column.
private static void	fillWithRandomChars(java.util.Random r, char[] chars) Fill a char array with random characters.
private java.sql.PreparedStatement	getOrPrepareStatement(java.lang.String sql) Get the prepared statement that we use in the test.
static junit.framework.Test	suite() Create a test suite with all the test cases in this class.
protected void	tearDown() Do the necessary clean-up after running the test.
void	varchar10() Test the performance of an index scan on a VARCHAR(10) column.
void	varchar100() Test the performance of an index scan on a VARCHAR(100) column.
void	varchar1000() Test the performance of an index scan on a VARCHAR(1000) column.
void	varcharAll() Test the performance of an index scan with a compound index on columns with type VARCHAR(10), VARCHAR(100) and VARCHAR(1000).

Methods inherited from class org.apache.derbyTesting.junit.JDBCPerfTestCase

runBareOverridable, runTest

Methods inherited from class org.apache.derbyTesting.junit.BaseJDBCTestCase

assertCallError, assertCheckTable, assertCompileError, assertEquals, assertEquals, assertEquals, assertEquivalentDataType, assertErrorCode, assertGetIntError, assertNextError, assertPreparedStatementError, assertSQLExceptionEquals, assertSQLState, assertSQLState, assertStatementError, assertStatementError, assertStatementError, assertStatementError, assertStatementErrorUnordered, assertTableRowCount, assertUpdateCount, assertUpdateCount, assertWarning, checkAllConsistency, checkEstimatedRowCount, closeStatement, commit, createStatement, createStatement, createStatement, dropTable, dropTable, dropView, dropView, emptyStatementCache, getClientTransactionID, getConnection, getDatabaseProperty, getLastSQLException, initializeConnection, openConnection, openDefaultConnection, openDefaultConnection, openDefaultConnection, openUserConnection, prepareCall, prepareCall, prepareCall, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, rollback, runBare, runScript, runScript, runSQLCommands, setAutoCommit, usingDB2Client, usingDerbyNetClient, usingEmbedded

Methods inherited from class org.apache.derbyTesting.junit.BaseTestCase

alarm, assertDirectoryDeleted, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertExecJavaCmdAsExpected, assertLaunchedJUnitTestMethod, assertLaunchedJUnitTestMethod, assertSecurityManager, assertThrowableEquals, currentDirectory, execJavaCmd, execJavaCmd, fail, getClassVersionMajor, getEmmaJar, getFailureFolder, getFilesWith, getJavaExecutableName, getSystemProperty, getTestConfiguration, getTestResource, hasInterruptibleIO, isCVM, isIBMJVM, isJ9Platform, isJava5, isJava7, isJava8, isPhoneME, isPlatform, isSunJVM, isWindowsPlatform, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeFiles, removeSystemProperty, runsWithEmma, runsWithJaCoCo, setSystemProperty, sleep, sleepAtLeastOneTick, traceit

Methods inherited from class junit.framework.TestCase

assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertFalse, assertFalse, assertNotNull, assertNotNull, assertNotSame, assertNotSame, assertNull, assertNull, assertSame, assertSame, assertTrue, assertTrue, countTestCases, createResult, fail, fail, failNotEquals, failNotSame, failSame, format, getName, run, run, setName, setUp, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

preparedStmt

private java.sql.PreparedStatement preparedStmt

The prepared statement for the SQL expression that we want to test.

Constructor Detail

IndexScanTest

private IndexScanTest(java.lang.String name,
                      int iterations,
                      int repeats)

Create an instance of the test.

Parameters:

name - the name of the method to call in the test

iterations - the number of iteration in each test run

repeats - the number of times each test run is repeated

Method Detail

getOrPrepareStatement

private java.sql.PreparedStatement getOrPrepareStatement(java.lang.String sql)
                                                  throws java.sql.SQLException

Get the prepared statement that we use in the test. If this is the first time the method is called on this object, prepare the statement and then return it.

Parameters:

sql - the SQL text to prepare if the statement isn't already compiled

Returns:

the prepared statement to use in this test

Throws:

java.sql.SQLException

tearDown

protected void tearDown()
                 throws java.lang.Exception

Do the necessary clean-up after running the test.

Overrides:

tearDown in class BaseJDBCTestCase

Throws:

java.lang.Exception

suite

public static junit.framework.Test suite()

Create a test suite with all the test cases in this class.

Returns:

a test suite

fillWithRandomChars

private static void fillWithRandomChars(java.util.Random r,
                                        char[] chars)

Fill a char array with random characters.

Parameters:

r - a random number generator

chars - the array to fill

varchar10

public void varchar10()
               throws java.sql.SQLException

Test the performance of an index scan on a VARCHAR(10) column.

Throws:

java.sql.SQLException

varchar100

public void varchar100()
                throws java.sql.SQLException

Test the performance of an index scan on a VARCHAR(100) column.

Throws:

java.sql.SQLException

varchar1000

public void varchar1000()
                 throws java.sql.SQLException

Test the performance of an index scan on a VARCHAR(1000) column.

Throws:

java.sql.SQLException

varcharAll

public void varcharAll()
                throws java.sql.SQLException

Test the performance of an index scan with a compound index on columns with type VARCHAR(10), VARCHAR(100) and VARCHAR(1000).

Throws:

java.sql.SQLException

decimal1column

public void decimal1column()
                    throws java.sql.SQLException

Test the performance of an index scan on a DECIMAL(10,10) column.

Throws:

java.sql.SQLException

decimal10columns

public void decimal10columns()
                      throws java.sql.SQLException

Test the performance of an index scan on a compound index on ten DECIMAL(10,10) columns.

Throws:

java.sql.SQLException