Uploaded image for project: 'AeroGear'
  1. AeroGear
  2. AEROGEAR-6182

Improve getNumberOfPushMessagesForLoginName JPQL

    XMLWordPrintable

Details

    • Enhancement
    • Resolution: Done
    • Major
    • None
    • None
    • None
    • IR289 PushDocker
    • 8

    Description

      Query for "getNumberOfPushMessagesForLoginName()" in "JPAPushMessageInformationDao" is not the best:

      https://github.com/aerogear/aerogear-unifiedpush-server/blob/1.1.x-dev/model/jpa/src/main/java/org/jboss/aerogear/unifiedpush/jpa/dao/impl/JPAPushMessageInformationDao.java#L89-L91

      Execution of the query can take long time, while running the query in different, separate parts gives much better result.

      I've pinged gunnar.morling for help on this

      Attachments

        Issue Links

          relates to

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. AEROGEAR-3240 UPS Query improvements and Hibernate Cache tweaks

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Activity

            People

              Unassigned Unassigned
              mwessend@redhat.com Matthias Wessendorf
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: