Overview  Package   Class  Use  Deprecated  Index
Home >> All >> org >> hsqldb >> [ test overview ]	PREV CLASS  NEXT CLASS
SUMMARY:  JAVADOC |  SOURCE |  DOWNLOAD | NESTED | FIELD | CONSTR | METHOD	DETAIL: FIELD | CONSTR | METHOD

---

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

---

Field Summary
(package private)  boolean	addForeignKey
(package private)  java.sql.Connection	cConnection
(package private)  boolean	createTempTable
(package private)  boolean	deleteWhileInsert
(package private)  int	deleteWhileInsertInterval
protected  java.lang.String	filepath
(package private)  boolean	indexLastName
(package private)  boolean	indexZip
(package private)  java.lang.String	password
(package private)  boolean	refIntegrity
(package private)  java.sql.Statement	sStatement
protected  java.lang.String	url
(package private)  java.lang.String	user

 

Constructor Summary

TestCacheSize()

 

Method Summary
protected  void	checkResults()
static void	main(java.lang.String[] argv)
protected  void	setUp()
protected  void	tearDown()
void	testFillUp()           Fill up the cache

 

Methods inherited from class java.lang.Object

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

 

Field Detail

url

protected java.lang.String url

---

filepath

protected java.lang.String filepath

---

user

java.lang.String user

---

password

java.lang.String password

---

sStatement

java.sql.Statement sStatement

---

cConnection

java.sql.Connection cConnection

---

indexZip

boolean indexZip

---

indexLastName

boolean indexLastName

---

addForeignKey

boolean addForeignKey

---

refIntegrity

boolean refIntegrity

---

createTempTable

boolean createTempTable

---

deleteWhileInsert

boolean deleteWhileInsert

---

deleteWhileInsertInterval

int deleteWhileInsertInterval

Constructor Detail

TestCacheSize

public TestCacheSize()

Method Detail

setUp

protected void setUp()

---

testFillUp

public void testFillUp()

Fill up the cache

---

tearDown

protected void tearDown()

---

checkResults

protected void checkResults()

---

main

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

---

Overview  Package   Class  Use  Deprecated  Index
Home >> All >> org >> hsqldb >> [ test overview ]	PREV CLASS  NEXT CLASS
SUMMARY:  JAVADOC |  SOURCE |  DOWNLOAD | NESTED | FIELD | CONSTR | METHOD	DETAIL: FIELD | CONSTR | METHOD

---