org.hsqldb.test
Class TestCacheSize

java.lang.Object
  extended byorg.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. 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

Author:
fredt@users

Constructor Summary
TestCacheSize()
           
 
Method Summary
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)


Copyright © 2001 - 2002 HSQL Development Group. All Rights Reserved.