0 Replies Latest reply on Aug 17, 2016 2:52 AM by Lavesh Rawat

    Openfire Optimization Issues

    Lavesh Rawat

       

      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='?'

       

      http://download.igniterealtime.org/openfire/docs/latest/documentation/database-g uide.html

      https://community.igniterealtime.org/docs/DOC-1673

      I don't understand what all cache means.

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