Bug in jdbcUserProvider.allUsersSQL

Hi,

The JDBCUserProvider::getUsers() calls JDBCUserProvider::getUsernames() with numResults set to Integer.MAX_VALUE.

As I have ~200’000 Users in the connected DB, this leads to a big problem, as I cannot load the Userlist-Page anymore and it slows down my DB Server.

Why is this done like this? I think this is a bug, because the Webinterface Userlist has a Paging and I cannot see a reason, why this is somehow ignored.

Thanks for your support, Openfire is really a great jabber server.

  • Michael

Does anyone now how this could be fixed?

how to fixed it???

Looks like a simple fix … opened OF-659 to track.

1 Like