Re: [Hibernate] some performnace metric for the dirty check during hibernate flush.

2003-09-16 Thread Gavin King
I should also point out that 0.13ms per object is an absolute best possible case for the database access. This is reading straight out of Oracle's cache on a local machine, with no concurrent threads. In a real system, the database access would be MUCH slower than that! Gavin King wrote: Listen, I

Re: [Hibernate] Performance Problem - lots of many-to-one associa tions

2003-09-16 Thread Gavin King
0.3 seconds is an awfully long time for loading _one_row_! Joseph Toth wrote: Ahha, outer-join="false" was the key ... Now it only takes 0.3 seconds to load that object! Thank you so much! -Original Message- From: Gavin King [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003

Re: [Hibernate] Performance Problem - lots of many-to-one associations

2003-09-16 Thread Juozas Baliuka
I am not sure it can help for you, but sometimes I use this for "readonly" data : transform tables like "TBL_CITY" or "TBL_COUNTRY" to "properties" file and store this data on client side. > Using Hibernate 2.0.3 > > We have a table "panel_demographics" (xml at bottom) which holds foreign > ke

Re: [Hibernate] Performance Problem - lots of many-to-one associations

2003-09-16 Thread Gavin King
All the foreign tables should be cached indefinately. There are only a couple rows in each. Is a way for hibernate to, when loading PanelDemographics, the sql generated would just select the id's of the foreign tables, then grab the objects from the cache. Absolutely. Enable JCS on the associated

[Hibernate] Performance Problem - lots of many-to-one associations

2003-09-16 Thread Joseph Toth
Using Hibernate 2.0.3 We have a table "panel_demographics" (xml at bottom) which holds foreign keys to many other tables. These other (metadata) tables all look basically the same, at the bottom "Education" is an example. A query like: PanelDemographics panelDemographics = (PanelDemographics) ses

Re: [Hibernate] some performnace metric for the dirty check during hibernate flush.

2003-09-16 Thread Gavin King
Listen, I really don't have time to waste explaining to you how to do proper benchmarks in a Hotspot-style JVM! But, for a start, any tests _not_ done in a loop are absolutely meaningless! In my *much* more scientific tests, I find that the flush time per object is about 0.01ms (about 1/7th of what

[Hibernate] [Announce] Release 2 Middlegen Plugin Released.

2003-09-16 Thread David Channon
Please find the src for the latest version of the Hibernate plugin. This is release two which represents a few enhancements and a number of bug fixes. The following is what has been included: o Fields that were for display purposes only where changes would not be persisted will no longer allow you

RE: [Hibernate] Is it possible to execute sql insert statements with hibernate / hibernate serssion object?

2003-09-16 Thread Oisin Kim
Thanks Christian, That's a great assest to our tool chest! Can you tell me how it affects Hibernate's caching? Or is there somewhere I can read how it might, without searching the sourcecode? Thanks again, Oisin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Beh

Re: [Hibernate] Is it possible to execute sql insert statements with hibernate / hibernate serssion object?

2003-09-16 Thread Christian Bauer
On 16 Sep (13:54), Oisin Kim wrote: > "Query q = session.createSQLQuery( "select {e}.empno as {e.empno}, > {e}.firstnme as {e.firstnme}, {e}.lastname as {e.lastname} from employee > {e}", "e", Employee.class );" > > I haven't been able to find this method in the current javadocs at > http://www.h

[Hibernate] Is it possible to execute sql insert statements with hibernate / hibernate serssion object?

2003-09-16 Thread Oisin Kim
Hi All, I've just started workign with Hibernate and have run into something which looks like it used to have a (partial) solution to at: http://forum.hibernate.org/viewtopic.php?t=463&highlight=createsqlquery Which shows the following : "Query q = session.createSQLQuery( "select {e}.empno as {e.

Re: [Hibernate] some performnace metric for the dirty check during hibernate flush.

2003-09-16 Thread Patrick Burleson
At 02:29 AM 9/16/2003 -0700, jiesheng zhang wrote: ---test logic 1. load some (n) number of objects in memory. 2. begin tranaction. 3. // do not do anything here. 4. commit. Then calculate the time consumed from step 2 and 4. test code ---

[Hibernate] some performnace metric for the dirty check during hibernate flush.

2003-09-16 Thread jiesheng zhang
Hi, I once suspect that hibernate take too much time in doing dirty check during session flush. However Gavin king and other hibernate-user disagreed with me. I did a simple performance testing to verify the dirty check performance. My conslusion is that the performance is not so good if there a