Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 44617 invoked from network); 10 Jan 2005 17:33:08 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 10 Jan 2005 17:33:08 -0000 Received: (qmail 70295 invoked by uid 500); 10 Jan 2005 17:33:08 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 70087 invoked by uid 500); 10 Jan 2005 17:33:07 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 70074 invoked by uid 99); 10 Jan 2005 17:33:07 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: neutral (hermes.apache.org: local policy) Received: from pimout2-ext.prodigy.net (HELO pimout2-ext.prodigy.net) (207.115.63.101) by apache.org (qpsmtpd/0.28) with ESMTP; Mon, 10 Jan 2005 09:33:05 -0800 Received: from [67.122.108.251] (adsl-67-122-108-251.dsl.sntc01.pacbell.net [67.122.108.251]) by pimout2-ext.prodigy.net (8.12.10 milter /8.12.10) with ESMTP id j0AHWnXO130006 for ; Mon, 10 Jan 2005 12:32:59 -0500 Message-ID: <41E2BCF8.1020001@Mutagen.Net> Date: Mon, 10 Jan 2005 09:35:52 -0800 From: Jack Klebanoff User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.1) Gecko/20040707 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Discussion Subject: Re: Database Size Limit References: <200501101151.j0ABpAwE003398@Boron.MeepZor.Com> In-Reply-To: <200501101151.j0ABpAwE003398@Boron.MeepZor.Com> X-Enigmail-Version: 0.85.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Hong Ji wrote: > Hi, > > Does Derby have any limit on the database size? > > > > Thanks. > > Hong > A Derby database is stored in multiple files under one directory, so the database size is limited by the file system. The maximum database size is limited by the maximum that the file system allows in one partition. It is system dependent. By default the log files are stored on the same partition as the data, further limiting the database size. However the log files can be stored on a separate partition. Jack