org.apache.derbyTesting.perf.basic.jdbc

Class HeapScan

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.HeapScan

All Implemented Interfaces:

junit.framework.Test

Direct Known Subclasses:

CoveredIdxScan

public class HeapScan
extends JDBCPerfTestCase

Heap Scan tests

Field Summary

Fields

Modifier and Type	Field and Description
private boolean	binaryData
protected static int	rowcount
(package private) java.sql.PreparedStatement	select
private java.sql.PreparedStatement	selectWithPred
protected static java.lang.String	tableName

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
HeapScan(java.lang.String name, boolean binaryData, int iterations, int repeats) Scan tests.
HeapScan(java.lang.String name, int iterations, int repeats) Scan tests.

Method Summary

Modifier and Type	Method and Description
private static junit.framework.Test	baseSuite(java.lang.String name, boolean binaryData) Create a suite of all the tests in this class with the appropriate decorator.
void	initializeConnection(java.sql.Connection conn) Override initializeConnection to set the autocommit to false
void	Scan100() This test simply tests a heap scan which iterates through all the rows in the columns.
void	Scan100GetData() This test simply tests a heap scan which iterates through all the rows in the columns.
void	Scan100WithPredicate() Test the performance of a table scan that needs to compare all the char values in the table with some specified values.
void	setUp() Do the necessary setup for the test ,prepare the statement
static junit.framework.Test	suite()
void	tearDown() Cleanup - close resources opened in this test.

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, 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, toString

Methods inherited from class java.lang.Object

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

Field Detail

select

java.sql.PreparedStatement select

selectWithPred

private java.sql.PreparedStatement selectWithPred

tableName

protected static java.lang.String tableName

rowcount

protected static int rowcount

binaryData

private boolean binaryData

Constructor Detail

HeapScan

public HeapScan(java.lang.String name,
                int iterations,
                int repeats)

Scan tests.

Parameters:

name - test name

iterations - iterations of the test to measure

repeats - number of times to repeat the test

HeapScan

public HeapScan(java.lang.String name,
                boolean binaryData,
                int iterations,
                int repeats)

Scan tests.

Parameters:

name - test name

binaryData - whether or not binary data should be used instead of character data

iterations - iterations of the test to measure

repeats - number of times to repeat the test

Method Detail

suite

public static junit.framework.Test suite()

Returns:

suite of tests

baseSuite

private static junit.framework.Test baseSuite(java.lang.String name,
                                              boolean binaryData)

Create a suite of all the tests in this class with the appropriate decorator.

Parameters:

name - the name of the returned test suite

binaryData - whether or not these tests should use binary data instead of character data

Returns:

a test suite

setUp

public void setUp()
           throws java.lang.Exception

Do the necessary setup for the test ,prepare the statement

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.lang.Exception

initializeConnection

public void initializeConnection(java.sql.Connection conn)
                          throws java.sql.SQLException

Override initializeConnection to set the autocommit to false

Overrides:

initializeConnection in class BaseJDBCTestCase

Parameters:

conn - Connection to be intialized

Throws:

java.sql.SQLException - Error setting the initial state.

Scan100

public void Scan100()
             throws java.lang.Exception

This test simply tests a heap scan which iterates through all the rows in the columns. The column data are not retrieved using getXXX

Throws:

java.lang.Exception

Scan100GetData

public void Scan100GetData()
                    throws java.lang.Exception

This test simply tests a heap scan which iterates through all the rows in the columns. The column data are retrieved using getXXX

Throws:

java.lang.Exception

Scan100WithPredicate

public void Scan100WithPredicate()
                          throws java.sql.SQLException

Test the performance of a table scan that needs to compare all the char values in the table with some specified values. Used to test the performance gains in DERBY-4608.

Throws:

java.sql.SQLException

tearDown

public void tearDown()
              throws java.lang.Exception

Cleanup - close resources opened in this test.

Overrides:

tearDown in class BaseJDBCTestCase

Throws:

java.lang.Exception