2 Replies Latest reply: Mar 6, 2012 8:24 AM by Vishwa Kumba RSS

JBoss 1.4 Messaging - database persistence tables

Vishwa Kumba Newbie

I understand the foll. tables in the database to store JMS information as follows :

JBM_POSTOFFICE - stores the list of configured queues/topics
JBM_MSG - stores the individual messages as they arrive
JBM_MSG_REF - holds the relationship between a message and the destination(queue/topic)

 

As the volume of messages increases, the JBM_MSG and JBM_MSG_REF tables could grow very large.

I was wondering if this could lead to any performance issues. Is there a way to configure a seperate table to hold messages for each queue?