db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Matrigali <mikem_...@sbcglobal.net>
Subject Re: maximum file size
Date Fri, 10 Nov 2006 00:45:43 GMT
no, derby is limited by the file size limits of your os/jvm.  Derby 
itself can support files bigger than 4gig, but only if the OS/jvm
supports it.  Currently each table is limited to a single file.

redcloud wrote:
> Hi! I need to build a SQL table containing 1000000000 (!!!) rows. But i 
> filled up a table with 20000000 rows (file size of table 4GB) and my 
> filesystem denied to go on filling up the table. My question is: can 
> derby db build "infinitive" size table by chunking in multiple files?

View raw message