Ask Your Question
0

Is there a limit of the data in the database?

asked 2015-10-22 00:49:59 +0200

djr0379 gravatar image

Access has a two gig limit of data allowed in the database; SQL Server express has a four gig limit; does Base have a limit and if so, what is it?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2015-11-01 13:47:26 +0200

jay Arr gravatar image

updated 2015-11-02 13:30:48 +0200

I've culled this text from the HSQLDB site FAQ which may help answer your question:

What is the biggest known HSQLDB database? The current size limit of an HSQLDB database is 8 TB for all CACHED tables and 256GB for each TEXT table. In addition, maximum totall lob size is 64TB. If you use large MEMORY tables, memory is only limited by the allocated JVM memory, which can be several GB on modern machines and 64bit operating systems. We have performed extensive tests with the latest versions using the TestCacheSize and other test programs inserting millions of rows and resulting in data files of up to 16 GB and larger LOB sizes. Users have reported the use of databases with up top 900 million rows.

CLARIFICATION: The standard BASE database, which is HSQLDB v1.8 and integral to the .odb file, I believe (and i could be wrong) operates aa a single in-core file so it is likely that you'll be limited by the size of your computer's memory. However if you split the database and move to HSQLDB v2.3.3 then the above quoted limits apply.

If anyone else knows more please feel free to correct.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2015-10-22 00:49:59 +0200

Seen: 2,342 times

Last updated: Nov 02 '15