Using shared groups, loading a user roster can be a heavy duty process.
In my implementation each one of 10000 users belong to the same shared group.
I noticed (at least in sparkweb) openfire answers to the roster query with online and offline users (refer to bold prepared statement below).
Im afraid ~1Mb of roster has to be transferred for each roster initialization.
Is there any configuration option i missed?
Why cant only the online users be sent?
(Using online presence updates to add members to roster)
Im not very willing to change the following openfire class (RosterItemProvider) used by roster requests:
private static final String LOAD_ROSTER =
“SELECT jid, rosterID, sub, ask, recv, nick FROM ofRoster WHERE username=?”;
To a query that checks if the user isnt offline.
Is this a viable solution? Anyone has had this problem, or tried another solution?