[#7588] CB Activity showing everything of connections only?

And yes, the thought just occurred to me as well that maybe it has something to do with the large amount of connections. I have nearly 2500 connections, mainly because most people accept the automatic connection request.

That maybe the issue. I have yet to test such a usecase. I've already preemptively added a feature ticket to rewrite how connections activity are pulled from the database to avoid massive IN values (in your case the IN statement in SQL is over 2500 values).

forge.joomlapolis.com/issues/7588

Have added a note to test this against a user with a significant amount of connections. Aside from that I can't see any other reason this isn't working properly for your particular user. As you've confirmed it works fine for other users without a significant amount of connections then that likely confirms the inefficiency in CB Activity is the culprit and will have it fixed for CB Activity 5.0.0.

Thanks for your reply.

Do you still want me to send you login credentials in a private message? And if yes, should it be the login details of my main admin account which has nearly 2500 connections, or is another admin account ok?

If this is only impacting your admin with 2500 connections it's safe to assume that's the issue and will address it in CB Activity 5.0.0 where I'll be rewriting how connections are added to the Activity SQL (a subquery instead of a giant IN statement). There shouldn't be need for login credentials if that's the case since I believe we've found the issue. I'll be duplicating such a scenario locally to confirm (except I'll be testing with probably 10,000 connections or more).

Ok, was able to identify 2 core issues with the connections behavior in CB Activity. The first one is the connections query stopped at 200 users. So having 2500 of course meant a lot got cut off. Second is the query is inefficient. I'm working on reworking both behaviors to improve the performance and get rid of the limit.

Hello,

Thanks for the update. Yes, that would seem to be consistent with what I have noticed on my site. It's always the same posts of the same people I see, regardless of how old they are. So the system is probably only showing posts of the first 200 people I once made a connection with (and that I'm still connected with).

Hello,

Is there any timeframe known in which this update will be made?