Hi,
The "JVM wide system property derby.system.durability to the value true"
does just that (recommended by the Derby crowd).
And it has an effect, but surely not enough; my oracle installation runs
faster.
/max
There maybe some setting we are just missing for test purposes. For
example, I don't know about you, but on my Oracle setup I disable
recovery logging on the datafiles backing my test schema. Without
disabling this option, it is painfully slow to run the testsuite against
Oracle; and obviously I don't care about recovery of my test data ;).
Wasn't one of the Derby guys interested in helping us with any issues we
encountered in Derby usage/adoption?
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Max
Rydahl Andersen
Sent: Saturday, October 15, 2005 5:18 AM
To: Emmanuel Bernard
Cc: jboss-development@lists.sourceforge.net; Hibernate development
Subject: Re: [Hibernate] Re: [JBoss-dev] switch to derby in JB5?
Hi,
yes - there is alot more "weird" limitations, but Derby is not alone in
that
aspect (db2 comes to mind ;) But the turnaorund performance is
disappointing.
/max
AFAIR, the DDL generation fails on my test suite for this DB. They are
too strict in some are. So unless they've relaxed some restriction,
it's
a nope for me.
Max Rydahl Andersen wrote:
Hi,
A small FYI crosspost here since both communities has talked about
it.
Tonight I tried out Derby and followed the advise about running Derby
with the JVM wide system property derby.system.durability to the
value
test.
It certainly has an effect, but Derby is still sluggish with this
setting
compared to all other dbs on my box (mysql, oracle and hsql) - maybe
the dialect can be
tuned more; but as a development db HSQL still has a *much* better
turnaround
time.
/max
Sacha Labourey wrote:
I think that Alexey had evaluated it (right?) and mentionned it was
nowhere
close from the original closed source product. Maybe I am
mistaken...
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of
Max Rydahl Andersen
Sent: mardi, 20. septembre 2005 19:31
To: jboss-development@lists.sourceforge.net
Subject: Re: [JBoss-dev] switch to derby in JB5?
Its been very slow compared to using hsqldb with hibernate test
suite - at least the two times i tried to use it.
It seems like it is not very well optimized for DDL and queries
when running in embedded mode.
That might have changed, but it should at least be
tested/considered before changing away from the
test/developer friendly hsqld.
When Derby were named Cloudscape it actually had more sql features
and were faster...but apparently
they did their best to make it DB2 compliant ;)
/max
Its been asked in the past. Someone needs to validate that
it works as
the default db and update the service to start it. Alexey has a
prototype in varia:
org.jboss.jdbc.DerbyDatabase
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
Behalf Of Bill Burke
Sent: Tuesday, September 20, 2005 9:29 AM
To: jboss-development@lists.sourceforge.net
Subject: [JBoss-dev] switch to derby in JB5?
Should we switch to derby for JB5? Seems it is a fully
featured DB unlike Hypersonic which supports XA and everything.
-- Bill Burke
Chief Architect
JBoss Inc.
-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App
Server. Download
it for free - -and be entered to win a 42" plasma tv or
your very own
Sony(tm)PSP. Click here to play:
http://sourceforge.net/geronimo.php
_______________________________________________
JBoss-Development mailing list
JBoss-Development@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-development
-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App
Server.
Download
it for free - -and be entered to win a 42" plasma tv or
your very own
Sony(tm)PSP. Click here to play:
http://sourceforge.net/geronimo.php
_______________________________________________
JBoss-Development mailing list
JBoss-Development@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-development
-- --
Max Rydahl Andersen
callto://max.rydahl.andersen
Hibernate
[EMAIL PROTECTED]
http://hibernate.org
JBoss Inc
[EMAIL PROTECTED]
http://www.jboss.com/events/jbossworld
JBoss World Barcelona 10-12 October
-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App
Server.
Download
it for free - -and be entered to win a 42" plasma tv or your very
own
Sony(tm)PSP. Click here to play:
http://sourceforge.net/geronimo.php
_______________________________________________
JBoss-Development mailing list
JBoss-Development@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-development
-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server.
Download
it for free - -and be entered to win a 42" plasma tv or your very
own
Sony(tm)PSP. Click here to play:
http://sourceforge.net/geronimo.php
_______________________________________________
JBoss-Development mailing list
JBoss-Development@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-development
-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server.
Download
it for free - -and be entered to win a 42" plasma tv or your very
own
Sony(tm)PSP. Click here to play:
http://sourceforge.net/geronimo.php
_______________________________________________
JBoss-Development mailing list
JBoss-Development@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-development
--
--
Max Rydahl Andersen
callto://max.rydahl.andersen
Hibernate
[EMAIL PROTECTED]
http://hibernate.org
JBoss Inc
[EMAIL PROTECTED]
http://www.jboss.com/events/jbossworld
JBoss World Barcelona 10-12 October
-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
hibernate-devel mailing list
hibernate-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hibernate-devel
