RE : [mdr-dev] JdbcStorage update

Good news !!!! Adopting a JDBC storage would really help.

Olivier.

-----Message d'origine-----
De : Martin Matula [mailto:[email protected]]=20
Envoy=E9 : samedi 27 novembre 2004 23:54
=C0 : [email protected]
Objet : Re: [mdr-dev] JdbcStorage update


Hi John,
this is very interesting and comes at the right time. We are considering =

replacing our b-tree with something better for promoF, which is the=20
release after NetBeans 4.1 (it is too late for such change in 4.1). So=20
we will definitely look at the JdbcStorage and HSQLDB.
Regards,
Martin

John V. Sichi wrote:

> JdbcStorage has been broken for a while due to build changes and
> changes to the MDRCache class which JdbcStorage borrows from=20
> BTreeStorage.  I just checked in fixes so it should build and run=20
> again.  I also fixed some other bugs I found in my code.
>
> I'm finding that JdbcStorage with the latest release of HSQLDB running
> in-process appears to be even a little faster than BTree storage. =20
> This is just from casual observation with small data sets.  But it=20
> raises the question:  instead of continuing to put effort into the=20
> BTree library (e.g. enhancing with java.nio), why not replace it with=20
> an embedded Java database instead?  HSQLDB uses java.nio already, and=20
> supports both memory-based and disk-based tables.  Its license=20
> recently changed to new-BSD (the old advertising clause was removed)=20
> which is compatible with just about anything.  They claim performance=20
> has improved a lot, and it has crash recovery.
>
> Or if something more robust is required, there's Derby nee Cloudscape.
> I haven't tried it yet.
>
> JVS
>