AnsweredAssumed Answered

Openfire Optimization Issues

Question asked by Lavesh Rawat on Aug 17, 2016


I have found some optimisation issues in open-fire.



    1.  I am not using groups implementation, still below queries are getting fired.

    SELECT groupName FROM ofGroupUser WHERE username='?'.

    SELECT groupName from ofGroupProp WHERE ...


    2. Every now and then these queries are fired off no reason

    SELECT offlinePresence, offlineDate FROM ofPresence WHERE username='?'

    SELECT DISTINCT serviceID FROM ofPubsubNode WHERE serviceID='?' uide.html

I don't understand what all cache means.

So, Can some help us how to save these queries and does anyone have better documentation.