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: neutral (asf.osuosl.org: local policy)
Message-ID: <43DA5A74.1020507@sbcglobal.net>
Date: Fri, 27 Jan 2006 09:37:56 -0800
From: Mike Matrigali <mikem_app@sbcglobal.net>
Reply-To: mikem_app@sbcglobal.net
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
MIME-Version: 1.0
To: Derby Discussion <derby-user@db.apache.org>
Subject: Re: DB Tables on separate hardisks
References: <20060126163714.16654.qmail@web54005.mail.yahoo.com>
In-Reply-To: <20060126163714.16654.qmail@web54005.mail.yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

There is no support for this in Derby.  What is usually recommended in
this situation is to use the OS to stripe the 2 disks, and create a
single volume out of the 2 and then create the derby db on the single
volume.  I believe all the major OS's support this in some manner.

Melvin Zamora wrote:
> Hi Derbies,
> 
> Would it be possible to have the PK tables on hardisk-A and FK tables on 
> hardisk-B using only one database?
> 
> to envision:
> 
> CUSTOMER_DERBY_DB
> 
> CUSTOMER_TBL {PK} [HD-A], CUSTOMER_PURCHASES_TBL {FK} [HD-B]
> 
> -Melvin
> 
> ------------------------------------------------------------------------
> Do you Yahoo!?
> With a free 1 GB, there's more in store with Yahoo! Mail. 
> <http://us.rd.yahoo.com/mail_us/taglines/mailstorage/*http://mail.yahoo.com/> 
>