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 ------------------------------------------------------- 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
