hsqldb - 什么是 HSQLDB 限制？

Question

DB 中的表数量有限制吗？
模式内的表数量是否有一些限制？

Answer 1

希望这可以帮助

What are the limitations of the database (size of columns, number of tables, rows...)?

There is no imposed limitation. Number of columns, tables, indexes, size of columns and so on is limited only by the memory. For example, a user reported using a SELECT statement with 41 LEFT OUTER JOIN clauses on a huge database for a data mining application.

The current (2.0) size limit of an HSQLDB database is 16GB (by default) for all CACHED tables and 2GB for each TEXT table. If you use large MEMORY tables, memory is only limited by the allocated JVM memory, which can be several GB on modern machines and 64bit operating systems. Extensive tests have been made with the latest versions using the TestCacheSize and other test programs inserting millions of rows and resulting in data files of up to 16 GB and larger LOB sizes.

(source)

提供更新的常见问题解答 here .特找版块 Reliability, Performance and Deployment .

The current size limit of an HSQLDB database is 8 TB for all CACHED tables and 256GB for each TEXT table...