Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: domain of rick.hillegas@oracle.com
 designates 141.146.126.69 as permitted sender)
Message-ID: <52CEA657.1060504@oracle.com>
Date: Thu, 09 Jan 2014 05:38:31 -0800
From: Rick Hillegas <rick.hillegas@oracle.com>
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.7; en-US;
 rv:1.9.2.18) Gecko/20110616 Thunderbird/3.1.11
MIME-Version: 1.0
To: derby-user@db.apache.org
Subject: Re: Biggest Apache Derby database(s).
References: 
 <CAF4RT5TxDULT9DYmyD+V=xjWPa7bhB0+nvG4QvTV7i=YrgMf=Q@mail.gmail.com>
In-Reply-To: 
 <CAF4RT5TxDULT9DYmyD+V=xjWPa7bhB0+nvG4QvTV7i=YrgMf=Q@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 1/8/14 10:33 PM, Paul Linehan wrote:
> Hi all,
>
> I would like to know (with references/URLs preferably) what are the
> kinds of sizes that large Derby installs stretch to? Would it go to 1TB?
> More? Less?
>
> Thanks in advance for any info, pointers and esp. references and URLs.
>
>
> Rgs,
>
>
>
> Paul...
>
>
Hi Paul,

At Sun Microsystems we ran a stress test on a Derby database which 
successfully grew to 500GB. At that point, we halted the test, not 
because it was failing, but because we had satisfied ourselves that 
Derby could handle large data sets. However, I can't give you an URL 
because those test results weren't hosted on a public server.

I have no reason to believe that Derby wouldn't scale to 1TB as well.

Hope this helps,
-Rick