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='?'
I don't understand what all cache means.
So, Can some help us how to save these queries and does anyone have better documentation.