[jboss-user] [JBoss Messaging] - Re: Poss solution frequent deadlocks on SQLServer

[timfox]

"Jeremy Stone" wrote : 
  | 
  |    CREATE_IDX_MESSAGE_REF_TX=CREATE INDEX JBM_MSG_REF_TX ON JBM_MSG_REF (TRANSACTION_ID, STATE)
  |   | 
  | 
  | Not sure yet if this will have any undesired side effects or whether the same change should be applied for other database persistence serices.
  | 
  | Any thoughts?

Instead of adding the state column to the JBM_MSG_REF_TX index, does it also solve your problem by adding a new index solely on the state column.

e.g. CREATE INDEX TEST_INDEX_STATE ON JBM_MSG_REF(STATE). ?

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4104961#4104961

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4104961