db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David W. Van Couvering" <David.Vancouver...@Sun.COM>
Subject Re: DB Tables on separate hardisks
Date Fri, 27 Jan 2006 17:26:29 GMT
Well, it's tricky to do symbolic links since Derby creates the tables 
within a directory.  I guess what you could do is create the tables, 
shut down Derby, move the table(s) to a different disk device, create a 
soft link, and start Derby up again.  Hey, that might work! (ever the 
optimist)

David

Michael Segel wrote:
> On Thursday 26 January 2006 3:19 pm, Rajesh Kartha wrote:
> 
>>Only the database logs can be put on a separate device using the
>>'logDevice' attribute
>>
>>http://db.apache.org/derby/docs/10.1/adminguide/cadminlog98.html
>>
>>Please refer the Derby Admin Guide for more information on this.
>>
>>-Rajesh
>>
> 
> Well....
> 
> If you wanted to do something down and dirty, you could always have a couple 
> of different instances running and then connect to the correct instance to 
> write the table out and have each instance point to a different directory.
> (But that's a lot of headache and its going to be a nightmare to maintain.)
> 
> I guess there may be one other option, that might work.
> 
> Has anyone tried doing either symbolic links or hard links? How will Derby 
> handle this? In theory, it should work....
> 
> 
>>On 1/26/06, David W. Van Couvering <David.Vancouvering@sun.com> wrote:
>>
>>>My understanding is this is not possible right now with Derby.
>>>
>>>David
>>>
>>>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/
> 
> 

Mime
View raw message