CODEWITHSUNDEEP
javaderby
user542719
user542719

Reputation: 307

how much capacity Embedded derby has?

how much data java derby DB can store?

Upvotes: 7

Views: 5839

Answers (1)

Aito
Aito

Reputation: 6872

Here the FAQ

What is the size limit of a database? A: Java DB stores each base table and each index in a single file, so the data size limit is the file size limit of the JVM and OS on which it runs. Derby is coded against the Java 64 bit interfaces to access these files, so internally the maximum table size is approximately 2*64. The number of tables is only limited by the 64 bit length of table identifiers, for an approximate limit of 2*64 total tables. In practice, system resources such as disk space are a more likely source of size limitations. Java DB is tested on a database using over 350 GB of raw disk space with tables containing over 500 million tuples.

Upvotes: 11

Related Questions