Uploaded image for project: 'ActiveMQ'
  1. ActiveMQ
  2. AMQ-6049

Add option to limit results from expensive queries

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 5.12.0
    • 5.13.0
    • JDBC
    • None

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

              dejanb Dejan Bosanac
              dejanb Dejan Bosanac
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: