[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-910) Queries consume more and more clockticks as Session life goes on

[Steve Ebersole (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-910?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steve Ebersole closed HHH-910.
------------------------------


Closing stale resolved issues

> Queries consume more and more clockticks as Session life goes on
> ----------------------------------------------------------------
>
>                 Key: HHH-910
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-910
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 3.1 beta 2
>         Environment: Confirmed on WinXP+MSSQL and OS X+MySQL.
> Hibernate 3.1b2, one Session per thread.
>            Reporter: Karl Wettin
>            Priority: Critical
>   Original Estimate: 8h
>  Remaining Estimate: 8h
>
> I haven't had time to trace it down in the Hibernate source code yet. I'll do it later this week if nobody beats me to it.
> As I have been importing huge amounts of data to my database, data that might be updates and that might be creations, I've have noticed that the querys takes more and more time. Starting at 3ms, 50000 queries later at 10 seconds to execute. In the begining I though it took more and more time since the number of rows in my tables grew, but 10 seconds? makePersistent and commit never took more time, just queries. 
> So then I decided to commit the transaction and recreate the Session every 50 instances made pesistent. Now it stays down. So there is something really bad going on with the Session.

-- 
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
-
For more information on JIRA, see: http://www.atlassian.com/software/jira