You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by Ove Nordstrom <ov...@ojn.se> on 2006/05/20 19:43:41 UTC

HowTo use derby at a CDC device --SavaJe Jasper S20

Hi,

I bought a SavaJe phone "Jasper S20"(http://www.savaje.com/show_device.html)
at JavaOne.

It is a Java ME /CDC 1.1 phone.

Have anyone installed derby on this device?

HowTo do it?

Regards,

Ove


Re: HowTo use derby at a CDC device --SavaJe Jasper S20

Posted by Dy...@Sun.COM.
Ove Nordstrom <ov...@ojn.se> writes:

> Hi,
>
> I bought a SavaJe phone "Jasper S20"(http://www.savaje.com/show_device.html)
> at JavaOne.
>
> It is a Java ME /CDC 1.1 phone.
>
> Have anyone installed derby on this device?
>
> HowTo do it?

One thing to look out for is the page cache size. It default is 1000
which amounts to 1000*4k = 4 Mb (assuming the default pageSize of 4 kb).

That is, unless this is automagically changed when running under CDC,
does anyone know?

Anyway, you could try setting it to a lower value.

See http://db.apache.org/derby/docs/10.1/tuning/
the section about Derby Properties

So if you start derby with -Dderby.storage.pageCacheSize=250 
the page cache should take up 1 Mb

HTH

-- 
dt

Re: HowTo use derby at a CDC device --SavaJe Jasper S20

Posted by Michael Andreasen <mi...@dunlops.com>.
Hi Ove,

I've been using Derby and hsqldb under CDC 1.1 for a while now, not on 
the J20 (yet!) but using J9 on Pocket PC 2003. I have really given up on 
both of them as the memory footprint is just too big on both. You need 
to 8-16 meg on both for them to really operate properly. Nether will 
load a 20,000 row table with one index in 8 meg including your app, 
that's just doing the inserts, never mind starting to do queries!

However, I have just the other day discovered db4o... wow this is 
something else! the best bit of software I have seen since google earth. 
It's not an SQL database it's an Object database. Rather than me harping 
on about it here, take a look for yourself, it's simply amazing.

http://www.db4o.com

I now have my application working great, it's faster, easier and handles 
even bigger tables... and currently all in under 3 meg.

It does take a bit of getting used to, as they is no joins. But once you 
do, there is no going back!

Let me know what you think?



Ove Nordstrom wrote:
>
> Hi,
>
> I bought a SavaJe phone “Jasper 
> S20”(http://www.savaje.com/show_device.html) at JavaOne.
>
> It is a Java ME /CDC 1.1 phone.
>
> Have anyone installed derby on this device?
>
> HowTo do it?
>
> Regards,
>
> Ove
>
> ------------------------------------------------------------------------
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.392 / Virus Database: 268.6.1/344 - Release Date: 19/05/2006
>