When using JBossMQ with the JDBC2 persistence manager for storing large amounts of persistent messages it is a good idea to put an index on the TXID+TXOP fields of JMS_MESSAGES table . There is no index creation in the default jbossmq-service.xml. It gave us a performance boost of factor 2,4 in a complex topic/queue store and forward scenario with multiple durable subscribers and high message counts.
Regards,
Ulf Schroeter
