org.hsqldb.test
Class TestTextTables
java.lang.Object
org.hsqldb.test.TestTextTables
- public class TestTextTables
- 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
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 |
TestTextTables
public TestTextTables()
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.