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?
|Retrieving data ...|