What are HSQLDB restrictions?

Question

Are there any restrictions on the number of tables inside the database? Are there any restrictions on the number of tables inside a schema?

Answer 1

Hope this helps

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

An imposed restriction does not exist. Number of columns, tables, indexes, column size, etc. Limited only by memory. For example, a user reported using a SELECT statement with 41 LEFT OUTER JOIN clauses in a huge database for a data mining application.

(2.0) HSQLDB 16 ( ) CACHED 2 TEXT. MEMORY, JVM-, GB 64- . TestCacheSize , 16 .

()

</" > FAQ . Reliability, Performance and Deployment.

HSQLDB 8 CACHED 256 TEXT...

Answer 2

. . Java /.

, (MEMORY, CACHED TEXT).