[jboss-dev-forums] [Design of Messaging on JBoss (Messaging/JBoss)] - Re: JMS specific columns in DB

[timfox]

Let me-reiterate.

The point of this task is to get the schema to a stable state so we don't have to writing migration scripts every time we do a release.

The columns I am considering removing are vestigial, they are not used in any joins. Also they more than likely negatively effect performance due to the extra unnecessary number of tables the database has to deal with.

If someone wants to find out the actual jms destination they can join the channel id to the channel mapper table.

If we're not going to remove them now, we will probably do so a few months down the line anyway, in which case we will have to write a migration script, and will have customers with a messy straggling database with some columns used, some columns not used. I.e. a support head ache. If everyone is using the same db schema then it makes a hell of a lot easier.

If we make changes to the schema as I suggest this means we can support pretty much any message type without changing the format. So we have stability, performance, future proofing, clarity and conciseness.

If someone really wants a normalised JMS specific database as Clebert would like, then they can create a JDBCPersistenceManager that does this.

Yes, this will be as slow as a tortoise on crutches, but it's possible.

IMO the default out of the box schema should be simple and performant and not contain redundant that seem to server no real purpose.

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

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