| java.lang.Object org.hsqldb.test.TestCacheSize
TestCacheSize | public class TestCacheSize (Code) | | 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
author: fredt@users version: 1.8.0 since: 1.7.0 |
addForeignKey | boolean addForeignKey(Code) | | |
cacheScale | int cacheScale(Code) | | |
cacheSizeScale | int cacheSizeScale(Code) | | |
createTempTable | boolean createTempTable(Code) | | |
deleteWhileInsert | boolean deleteWhileInsert(Code) | | |
deleteWhileInsertInterval | int deleteWhileInsertInterval(Code) | | |
filedb | protected boolean filedb(Code) | | |
indexLastName | boolean indexLastName(Code) | | |
indexZip | boolean indexZip(Code) | | |
multikeytable | boolean multikeytable(Code) | | |
refIntegrity | boolean refIntegrity(Code) | | |
reportProgress | boolean reportProgress(Code) | | |
shutdown | protected boolean shutdown(Code) | | |
writeDelay | int writeDelay(Code) | | |
checkResults | protected void checkResults()(Code) | | |
deleteTest | void deleteTest()(Code) | | |
deleteZipTable | void deleteZipTable()(Code) | | |
selectID | void selectID()(Code) | | |
selectZip | void selectZip()(Code) | | |
selectZipTable | void selectZipTable()(Code) | | |
setUp | protected void setUp()(Code) | | |
storeResult | void storeResult(String description, int count, long time, long rate)(Code) | | |
tearDown | protected void tearDown()(Code) | | |
testFillUp | public void testFillUp()(Code) | | Fill up the cache
|
updateID | void updateID()(Code) | | |
updateIDLinear | void updateIDLinear()(Code) | | |
|
|