[
https://issues.apache.org/jira/browse/AMQ-6049?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dejan Bosanac resolved AMQ-6049.
--------------------------------
Resolution: Fixed
I added a general support on master with limitQuery() method that can be
implemented per adapter. I implemented Oracle version as well. Other adapters
can be handled in separate Jiras.
> Add option to limit results from expensive queries
> --------------------------------------------------
>
> Key: AMQ-6049
> URL: https://issues.apache.org/jira/browse/AMQ-6049
> Project: ActiveMQ
> Issue Type: Improvement
> Components: JDBC
> Affects Versions: 5.12.0
> Reporter: Dejan Bosanac
> Assignee: Dejan Bosanac
> Fix For: 5.13.0
>
>
> When using priority messages with JDBC store, a query that recovers messages
> from the db can be very expensive due to the sorting it has to do. The best
> way I found to improve the performance of that query is to limit the sorting
> set by limiting the number of entries expected from the query. This assumes
> changing the actual query and is vendor specific.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
