Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Tons of queries being run on a user's activity page #40

Open
r-a-y opened this issue May 7, 2015 · 3 comments
Open

Tons of queries being run on a user's activity page #40

r-a-y opened this issue May 7, 2015 · 3 comments
Assignees

Comments

@r-a-y
Copy link
Member

r-a-y commented May 7, 2015

When on a user's activity page - example.com/members/admin/activity - ~3000 DB queries are being run.

It mostly has something to do witi the event activity de-dupe code.

This doesn't seem to occur on any other activity pages such as the Sitewide Activity page or other user subnav activity pages.

@boonebgorges
Copy link
Member

What, don't you like it when 3000 queries run? What a wuss.

On 05/07/2015 04:28 PM, r-a-y wrote:

When on a user's activity page - |example.com/members/admin/activity| -
~3000 DB queries are being run.

It mostly has something to do witi the event activity de-dedupe code.

This doesn't seem to occur on any other activity pages such as the
Sitewide Activity page or other user subnav activity pages.


Reply to this email directly or view it on GitHub
#40.

@r-a-y
Copy link
Member Author

r-a-y commented May 7, 2015

💯

@boonebgorges
Copy link
Member

I've shaved this down by quite a bit. Most of it's now due to the fact
that BP does such a lousy job of caching group and group-membership
queries. I think it's probably good enough to ship for now. (Note that
te problem becomes much worse on dev environments where the last few
hundred activity items are related to events. On a real site like the
Commons, this won't happen.)

On 05/07/15 16:28, r-a-y wrote:

When on a user's activity page - |example.com/members/admin/activity| -
~3000 DB queries are being run.

It mostly has something to do witi the event activity de-dedupe code.

This doesn't seem to occur on any other activity pages such as the
Sitewide Activity page or other user subnav activity pages.


Reply to this email directly or view it on GitHub
#40.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants