http://www.h2database.com/html/advanced.html#limits_limitations


This database has the following known limitations:

Database file size limit: 4 TB (using the default page size of 2 KB) 
or higher (when using a larger page size). 
This limit is including CLOB and BLOB data.

The maximum file size for FAT or FAT32 file systems is 4 GB. 
That means when using FAT or FAT32, the limit is 4 GB for the data. 
This is the limitation of the file system. 
The database does provide a workaround for this problem, 
it is to use the file name prefix split:. 
In that case files are split into files of 1 GB by default. 
An example database URL is: jdbc:h2:split:~/test.

FAT or FAT32 文件系统限制，单个文件 4G 
split: 前缀 ， 文件分隔 


The maximum number of rows per table is 2^64.

The maximum number of open transactions is 65535.


Main memory requirements: The larger the database, the more main memory is required. 
With the current storage mechanism (the page store), 
the minimum main memory required is around 1 MB for each 8 GB database file size.

8G数据文件 使用的最小内存 1M



Limit on the complexity of SQL statements. 
Statements of the following form will result in a stack overflow exception:
SELECT * FROM DUAL WHERE X = 1
OR X = 2 OR X = 2 OR X = 2 OR X = 2 OR X = 2
-- repeat previous line 500 times --


There is no limit for the following entities, except the memory and storage capacity: 
maximum identifier length (table name, column name, and so on); 
maximum number of tables, columns, indexes, triggers, and other database objects; 
maximum statement length, 
number of parameters per statement, 
tables per statement, 
expressions in order by, group by, having, and so on; 
maximum rows per query; 
maximum columns per table, columns per index, indexes per table, lob columns per table, and so on; 

maximum row length, index row length, select row length; 
maximum length of a varchar column, decimal column, literal in a statement.

Querying from the metadata tables is slow if there are many tables (thousands).

For limitations on data types, see the documentation of the respective Java data type or the data type documentation of this database.