Openfire Optimization Issues

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 …

  1. 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.