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 (asf.osuosl.org: local policy)
Message-ID: <000f01c5a33f$81056a10$38577553@DB35TT0J>
From: "Piet Blok" <pbhome@wanadoo.nl>
To: "Derby Discussion" <derby-user@db.apache.org>
References: <8FA12926CCB8EC4CB47333C9B65F95D3015EDF03@EMAIL.atpiad1.local>
 <430209DD.9000009@sbcglobal.net> <43022028.8010001@sbcglobal.net>
 <200508161854.04743.msegel@segel.com>
Subject: Re: Quick question... on use with "Ram Drives" or FOBs...
Date: Wed, 17 Aug 2005 17:22:39 +0200
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 7bit

Hi Michael,

Yes, I tried to setup a (small) derby database on a memory stick (256 MB), 
and as expected this works fine.

I also installed the .jar file of an application (with embedded derby 
driver) on the stick.

I even installed a (windows) JRE on the memory stick and created a .bat file 
to start java explicitly from its JRE path.

Thus I was able to to run my application, including database, on any windows 
machine I encountered, with or without java installed, provided it had a 
working USB port.

Reasoning for this exercise was a prototype of an intelligent device that 
can be easily carried around and plugged in anywhere.

Startup performance is bad, but for the rest it works OK. (I am told by 
someone more familiar with memory sticks that performance is higly 
influenced by the machine's installed USB support, but I cannot comment on 
that).

(I assume FOBs refers to memory sticks?)

Piet Blok

----- Original Message ----- 
From: "Michael J. Segel" <msegel@segel.com>
To: "Derby Discussion" <derby-user@db.apache.org>
Sent: Wednesday, August 17, 2005 1:54 AM
Subject: Quick question... on use with "Ram Drives" or FOBs...


> Hi,
>
> Quick question...
>
> Has anyone tried using Derby/Cloudscape with the data being written to one 
> of
> those 512MB FOBs instead of a hard drive?
>
> Got in to a discussion over a beer last night regarding "in memory" 
> databases
> vs solid state drives vs those FOBs that now have over a GB of storage.
>
> Trying to see if we can improve performance by a simple hardware 
> change....
>
> Thoughts?
>
> -- 
> Michael Segel
> Principal
> MSCC
> (312) 952-8175
>
>