I work with an online gaming company and will be switching to using XMPP for our chat and game servers.
We have experimented with Openfire, and it seems like it can do the job. So far we can authenticate and provide user info by using the JDBC providers.
However, we also have a “friendlist” already and this probably should be provided as a roster, but how do I do that? I don’t find a JDBCRosterProvider class.
Another thing…we have over a million users in the database, so the ‘jdbcUserProvider.allUsersSQL’ really stresses the network and database. Is there any way of limiting the result? I simply added ‘LIMIT 10’ and the ‘jdbcUserProvider.userCountSQL’ is implemented as ‘SELECT 10’, but this seems like an ugly hack to me.