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

[jwcone]

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#4091139

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