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