What steps will reproduce the problem? 1. Create a lot of users, ~100 2. Login with few of them and add everyone to your roster 3. Repeat with few users, don't accept inbound subscriptions 4. Login with some of that user who has everyone in the roster What is the expected output? Expected to login without database request for each offline contact What do you see instead? Tons of request to the database. What version of the product are you using? On what operating system? Trunk Please provide any additional information below. As was mentioned, the main issue is non-optimal behavior in is_contact_pending_in.

Thanks for the report. Please check if this is still a problem after the roster cache was added See #1233 https://hg.prosody.im/trunk/rev/42a3e3a28248

• tags Status-NeedInfo
• owner Zash

I will interpret silence as it works

• tags Status-Fixed