Use custom user tables with Java heap space


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

  1. I wonder if openfire is ignoring the pagination and get all members? (that’s nonsense tho).

  2. How should I set up the sql for large member lists?