You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@activemq.apache.org by "Dejan Bosanac (JIRA)" <ji...@apache.org> on 2015/11/18 12:05:11 UTC

[jira] [Created] (AMQ-6049) Add option to limit results from expensive queries

Dejan Bosanac created AMQ-6049:
----------------------------------

             Summary: 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)