What is the biggest known Hsqldb Database?
* The maximum size limit of an HSQLDB database is currently 8 TB for all CACHED tables and 256GB for each TEXT table.
* The maximum total lob size is 64TB.
* If you use large MEMORY tables, the memory limit is only restricted by the allocated JVM memory, which can be several GB on modern machines and 64bit operating systems.
* Tests have been performed with the latest versions of HSQLDB using the TestCacheSize and other test programs inserting millions of rows, resulting in data files of up to 16 GB and larger LOB sizes.
* Users have reported successfully using HSQLDB databases with up to 900 million rows.
