search

cuny-academic-commons / bp-event-organiser

Allows Event Organiser plugin events to be assigned to BuddyPress groups and generates a group calendar page for each group
GNU General Public License v2.0
3 stars 1 forks source link

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

Open r-a-y opened 9 years ago

r-a-y commented 9 years ago

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 commented 9 years ago

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 https://github.com/cuny-academic-commons/bp-event-organiser/issues/40.

r-a-y commented 9 years ago

:100:

boonebgorges commented 9 years ago

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 https://github.com/cuny-academic-commons/bp-event-organiser/issues/40.