org.hsqldb.test

Class TestCacheSize

java.lang.Object

org.hsqldb.test.TestCacheSize

public class TestCacheSize
extends java.lang.Object

Test large cached tables by setting up a cached table of 100000 records or more and a much smaller memory table with about 1/100th rows used. Populate both tables so that an indexed column of the cached table has a foreign key reference to the main table. This database can be used to demonstrate efficient queries to retrieve the data from the cached table. 1.7.1 insert timings for 100000 rows, cache scale 12: simple table, no extra index: 52 s with index on lastname only: 56 s with index on zip only: 211 s foreign key, referential_integrity true: 216 s The above have improved a lot in 1.7.2 This test now incorporates the defunct TestTextTables

Since:

1.7.0

Constructor Summary

Constructors

Constructor and Description
TestCacheSize()

Method Summary

Modifier and Type	Method and Description
static void	main(java.lang.String[] argv)
void	testFillUp() Fill up the cache

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

TestCacheSize

public TestCacheSize()

Method Detail

testFillUp

public void testFillUp()

Fill up the cache

main

public static void main(java.lang.String[] argv)