Message:
The following issue has been closed.
Resolver: Gavin King
Date: Wed, 12 Nov 2003 8:48 PM
This difference is due to the removal of the PreparedStatement cache in 2.1. Try using the DBCP connection provider which does prepared statement caching.
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-466
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-466
Summary: 2.1 beta6 slow?
Type: Bug
Status: Closed
Priority: Major
Resolution: WON'T FIX
Project: Hibernate2
Assignee:
Reporter: Daniel Rosenbaum
Created: Wed, 12 Nov 2003 4:13 PM
Updated: Wed, 12 Nov 2003 8:48 PM
Environment: Windows XP 1.66 GHZ 512 megs ram
Description:
When running the same code with both 2.0.3 and 2.1 beta 6, the beta runs much slower when doing an iterate().
This is the result of a discussion on the Beginners forum at http://forum.hibernate.org/viewtopic.php?t=925487
With my sample code, running using the 2.0.3 jars took 14435 ms to get appox 700 objects from the db, but with the beta it took 45618 ms, about 3 times slower. I repeated this test a number of times with similar results.
I provided the classes, xml files and props. I also provided logs, one set with SQL logging and one without (the sql logging logs show greater execution time due to the extra i/o involved in logging the SQL).
Is it only on my system that this is happening?
Note also that I am not sure if anyone would even be able to execute the code, since it uses a db table I have in my db. I suppose one can do schemaexport and populate the resulting table with 700 rows.
Thank you.
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
