Hi,
We are using our existing tables for the auth and user.
But when I clicked the users/groups module, it wait a long while and returned:
Java heap space
In openfire.xml, my related sql is:
SELECT id FROM member
When I limit the return then no error happens:
SELECT id FROM member limit 100
The problem of the new sql is it always select the first 100 users
-
I wonder if openfire is ignoring the pagination and get all members? (that’s nonsense tho).
-
How should I set up the sql for large member lists?
Thanks,
Arthur