[hibernate-dev] Performance issues with HT_ tables?

[Marcel Stör]

On 14.12.2010 03:02, Steve Ebersole wrote:
> Those tables are used as part of bulk update/delete HQL processing

Thank you. That much I figured by now ;-)
However, this does not explain (for me) why
a) Why they are used at all in the situation I described - are they used 
for all bulk update/delete HQL operations regardless of context/mapping 
strategy?
b) Why the update in my situation runs for more than an hour. That's an 
absolute disaster because all other transaction fail with lock timeout.

> -- Sent from my Palm Pre
> On Dec 13, 2010 4:43 PM, Marcel Stör<marcel at frightanic.com> wrote:
> Sorry to ask for help on the dev list but it seems as if no regular user
> would ever have to deal with such low level issues.
>
> Since we're having serious performance problems (queries running more
> than an hour...) with HT_ tables I was looking for documentation that
> describes the when/why/how/etc. of temporary tables. It can't seem to
> find anything online or in the Hibernate books.
> All I find at http://www.google.com/search?q=hibernate%20%22HT_%22 are
> unanswered forum questions or dead JIRA entries.
>
> It'd be nice if one of the developers could point me into the right
> direction.
> -> Problem: https://forum.hibernate.org/viewtopic.php?f=1&t=1008637


-- 
Marcel Stör, http://www.frightanic.com
Couchsurfing: http://www.couchsurfing.com/people/marcelstoer
O< ascii ribbon campaign - stop html mail - www.asciiribbon.org