hsqldb v.1.61 Selftest Demo

There is a batch file provided in the demo directory. To startup the application on Windows type:

run SelfTest

To test inserting 30000 rows into one table, type:

run SelfTest 30000

To test inserting 10000 rows in the In-Memory-mode type only:

run SelfTest 10000 -m

SelfTest will first try to insert the rows into a cached table, and then into an in-memory table. The first part may work and the second part (in-memory table) may run out of memory if there is not enough memory available. You may experience a long 'delay' between updating and deleting records. This is by design: the recovery mechanism is tested here.