JBM_MSG_REF and JBM_MSG has no foreign key relationship?

[karianna]

Hi all,

I was just curious as to why there is no FK relationship between JBOSS_MSG and JBOSS_MSG_REF tables. We had a situation in development where we had JBM_MSG_REF entries with no corresponding JBM_MSG. We're pretty sure this was because something went in behind the scenes and edited the tables (not Jboss) but were just curious as to why it wasn't there.

Using JBM that comes with jboss-eap-4.3

[ataylor]

purely for performance reasons I think. adding referential constraints means it would take longer to insert a record, it wouldn't be much but since you could be writing 1000's of records a second it can add up. You could always add the FK your self if you thought it would be beneficial.

[karianna]

Thanks Andy,

We might do that for our low Txn JMS servers, just for comfort :)