[hibernate-dev] Performance issues with HT_ tables?

[Emmanuel Bernard]

I am not sure if that can help you but Steve has written some nice blog entries on the past on the subject

http://in.relation.to/Bloggers/MultitableBulkOperations
http://in.relation.to/Bloggers/BulkOperations

I'd say this content is still conceptually valid.

On 14 déc. 2010, at 08:04, Marcel Stör wrote:

> 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
> _______________________________________________
> hibernate-dev mailing list
> hibernate-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/hibernate-dev