CODEWITHSUNDEEP
javah2
BasK
BasK

Reputation: 292

H2 data base storage Capacity

I have a small question about storing data on a h2data database. How many records in an h2data database can we maximally store? Is there any limitation? If the data goes beyond this limitation what type of error does it give? Will the whole the system fail, or what else happens?

thank u

Upvotes: 2

Views: 3766

Answers (1)

Serge Ballesta
Serge Ballesta

Reputation: 149185

H2 is a lightweight database. As so it does have limitations. According to the page cited by Karthikeyan, the limit of 2^64 rows per table is a hard limit. If you try to write more, the insert will fail.

If you need more powerful databases, you could try the excellent PostgreSQL or MySql or MariaDB which will have less limitations.

Upvotes: 4

Related Questions