Full table scan for durable subs in jdbc store when priority enabled; very slow
with large message backlog
-----------------------------------------------------------------------------------------------------------
Key: AMQ-3188
URL: https://issues.apache.org/jira/browse/AMQ-3188
Project: ActiveMQ
Issue Type: Improvement
Components: Message Store
Affects Versions: 5.4.2
Environment: JDBC
Reporter: Gary Tully
Assignee: Gary Tully
Fix For: 5.5.0
Priority support is delegate to the DB, but it currently requires a full table
scan to recover a new batch of messages. This can be very slow when the message
table is large (a consumer has been offline for some time). With multiple
concurrent consumers this gets worse.
The store needs to use more internal state w.r.t priority such that
simpler/faster queries are used.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
