db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Iwan" <j...@i-ware.net>
Subject [PERFORMANCE] Torque vs. Hibernate
Date Fri, 05 Dec 2003 17:47:45 GMT

Does anybody have any experience, (or results), with performance tests
comparing Torque and Hibernate? We're currently using Hibernate, although I
like Torue better due to the simple format of the schema-definition file. We
have some performance issues with Hibernate and I was wondering if others
have moved from Hibernate to Torque for performance reasons.


> -----Original Message-----
> From: Göschl,Siegfried [mailto:Siegfried.Goeschl@drei.com] 
> Sent: Tuesday, December 02, 2003 12:19 PM
> To: torque-user@db.apache.org
> Subject: Torque 3.1 and Prepared Statements ....
> Hi folks,
> I try to convince the company I work for to use Torque 
> instead of the textbook "use entity beans with a session 
> facade plus manually written data transfer object and fill 
> your first dropdown box in two weeks time". To ensure that 
> Torque is doing well I wrote a regression test suite which 
> works fine. The last addition was testing of Prepared 
> Statements which showed a few problems
> +) The current implementation returns a List of 
> VillageRecords. Is there 
> +any reason why not to generate code which does the following 
> conversion 
> +automagically
> Foo.addSelectColumns( criteria );
> ... more criteria wrestling ..
> List recordList = FooPeer.doPSSelect( criteria );
> List result = FooPeer.populateObjects( recordList );
> +) There were question in the mailing list about prepared 
> statements and 
> +a lot of statement parsing within Oracle. I'm not pretty good at 
> +database and my last encounter with ODBC/JDBC is long and happily 
> +forgotten. But looking at the BasePeer.java I think what 
> could be the 
> +reason for that behaviour mentioned above. A conenction is 
> taken from 
> +the pool, a prepared statement is created from this connection, the 
> +query is done and at the end the statement is closed. AFAIK these 
> +forces the database to do the same parsing for the next prepared 
> +statement again.
> Does it make sense to store the prepared statement and all 
> the information needed to create it into a result returned 
> from BasePeer.createPreparedStatement()?! The prepared 
> statement could be reused, if the connection is broken the 
> prepared statement could be recreated using a good connection 
> and most of the parameter handling is already there?! Am I 
> completely on the wrong track?!
> Thanks in advance,
> Siegfried Goeschl
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org

To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org

View raw message