[jboss-user] [Messaging, JMS & JBossMQ] - Re: jdbc2 and firebird

A couple more notes on Firebird: If you want SELECT_MAX_TX to work like the Oracle version (i.e. operating on a union derived from JMS_MESSAGES and JMS_TRANSACTIONS) you can define the union as a VIEW, and then have SELECT_MAX_TX select from that VIEW. The JMS_MESSAGES_DESTINATION index is likely to have exceptionally poor http://www.firebirdfaq.org/faq167/ in many use cases. Since index selectivity can have a significant impact on Firebird performance, you might consider dropping it. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4091139#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...