Hi Michael- Below is the response from Lightning Base. Will this help give you an idea of the problem. I’ve reduced the number of users down to 450 as I had a great many spam users.
I really need this functionality as I have many teachers using the site and need to track their students progress. I’d be willing to explore some custom work from BadgeOS as well. In fact a few weeks back I made a request via your website but no one responded to me.
From Lightning Base:
“We’ve spent quite a while looking into this tonight. From what I can see, when the active users report is loaded, the database query effectively runs forever. PHP processes sit there waiting for it, and each of those issues can take down the site.
We did some experimenting but I don’t think this is something we can fix. My guess is that the report would be fine on most sites, but yours is extraordinarily complex, so it’s hard to say what it might be interacting with. There are numerous complex plugins installed, Multisite, and a >2.5 GB database. My suspicion is that having over 3000 users and a ~40 MB usermeta table is causing the query to take forever. But it could also be something related to all the other plugins. they might be interacting in a way that prevents the query from running properly.
I’m happy to look into this further if you or the developer has any thoughts / suggestions, but don’t know where else to go from here.”
