[jboss-dev-forums] [Design of Messaging on JBoss (Messaging/JBoss)] - Re: DB performances for large number of messages

[garu]

Continuing from previuos append.

I'd like to follow your suggestion to write myself the patch for this, after all, after many year, coding is still giving me fun, but i have such a tight schedule in my job that i cannot commit or promise anything.

I tried to figure out how it's working now (as a colleague said many years ago when there were still 300 baud modems around, it is not written as i would have written it so ,obviously, it's not working :) (i'm kidding, it is instead very well written) and i've got some ideas.

- Queue and Topic mbeans should have a couple of attributes like StoreName and RefStoreName. They could be both read/write with defaults in Queue-xmbean.xml and Topic-xmbean.xml of jbm_msg and jbm_msg_ref,  or perhaps only the first one could be r/w and RefStoreName could result from composition of StoreName + "_ref".
- those attribues should be available in a couple of columns into jbm_postoffice, so that when a queue is associated to a channel is also associated to specific StoreName and RefStoreName.
- those attributes should be available from Binding, Queue,and Topic so that they are available to persistence manager to get the table name to prime sql statements, that actually use jbm_msg and jbm_msg_ref, with the correct table name to read and write for that specific channel.
- whenever a binding is added to postoffice table the store tables must be created if not already present because other channels are already writing on them.
- whenever a binding is removed from postoffice table the store tables should be removed if empty (this could be conditioned by a a flag attribute in queue/topic mbean, it would be not worth removing them if the destination will be reused again)

Obviously this is the result of just a rapid overlook of the code, so i'm sure i missed many subtleties, but i'm interested to know what you think.

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

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