Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

how much capacity Embedded derby has?

Tags:

java

derby

how much data java derby DB can store?

like image 658
user542719 Avatar asked Jan 17 '11 20:01

user542719


People also ask

What is Derby embedded database?

Apache Derby (previously distributed as IBM Cloudscape) is a relational database management system (RDBMS) developed by the Apache Software Foundation that can be embedded in Java programs and used for online transaction processing. It has a 3.5 MB disk-space footprint.

Where is Derby data stored?

A Derby database is stored in files that live in a directory of the same name as the database. Database directories typically live in system directories. Contains files that make up the database transaction log, used internally for data recovery (not the same thing as the error log).

Is Derby an in memory database?

Derby mainly support on-disk database. It also provides in-memory database for testing and developing applications. By following backup procedures, in-memory database can be stored and be used as either an in-memory database or normal on-disk database at a later time.


1 Answers

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.

like image 192
Aito Avatar answered Sep 19 '22 16:09

Aito