soraclemedia

Sorry guys, if anything these are longer delays.

In the multisite tab from the Query Monitor plugin, I have 364 items like these below.

1switch_to_blog(3)1 → 3+

1. gamipress_get_plugin_active_sites()

Plugin: gamipressrestore_current_blog()1 ← 3+

1. gamipress_get_plugin_active_sites()

Plugin: gamipress2switch_to_blog(4)1 → 4+

1. gamipress_get_plugin_active_sites()

Plugin: gamipressrestore_current_blog()1 ← 4+

1. gamipress_get_plugin_active_sites()

Plugin: gamipress3switch_to_blog(5)1 → 5+

1. gamipress_get_plugin_active_sites()

Plugin: gamipressrestore_current_blog()1 ← 5+

1. gamipress_get_plugin_active_sites()

Plugin: gamipress4switch_to_blog(6)

My loading times are now about 20 seconds.

Thanks.

Thank you! I will test it all.

I think the problem is it being multisite related. In the Query monitor plugin, it shows that is appears to be switching “blogs” hundreds of times and I don’t know why.

• This reply was modified 8 months, 2 weeks ago by soraclemedia.

I have had an update from Siteground after their inspection and this is what they have said.

Thank you for the update, Rob.

I took the liberty of installing the following plugin below which helped me identify the issue causing the delay on the page:

https://www.ads-software.com/plugins/query-monitor/

It seems that for example when you go to the Men page from the home page there are 338 database queries sent from the Gamipress plugin like the ones below:

SELECT blog_id
FROM ***_blogs

They are called from the following PHP function in the plugin:

gamipress_get_network_site_ids()

There are also multiple other duplicated queries that you can find on the Duplicate Queries page on the Query Monitor plugin on the Dashboard when you reload the page:

https://tinyurl.com/26cay9v3

I tried disabling Memcached, flushing the cache from our Speed Optimizer plugin, changing the PHP setup from Ultrafast to Standard, and running optimize on the database with WP-CLI but no to avail. I also tried disabling Memcached to check if this will affect the performance but there was no impact.

In this case, my advice is to consider the case with the developers of the Gamipress plugin for assistance on this matter. They are aware of the plugin internals and should be able to determine what is causing the delay and how it can be fixed. I checked the server status as well and there are no issues with it.

If there is anything required from our end or you have any other issues or questions do not hesitate to contact us again!

Ah that is a shame. I was really looking forward to using Gamipress.

Hello,

Yes I have already done those.

The tables are already InnoDB, we use Siteground if that helps. The indexes are already set up too.

The site already has Memcached too.

Items 2 and 3 from the initial list don’t apply here because we haven’t got anything set up yet so no logs.

Thanks.

Hey,

Sorry for the delay in a response, have had my time taken over with other projects. I have had a chance to check now and the delay occurs when WooCommerce/Gamipress is flicked on or off. So in other words, it is very quick with all of my plugins and EITHER Gamipress or WooCommerce. This is the same if I have no other plugins at all activated apart from Gamipress and WooCommerce.

Not sure what to do about this.

Thanks,

Rob

Hey Dioni.

Cheers for the reply. For clarity, that was before I had created anything. Solely the difference between activated Gamipress and not activated.

Thanks.

Thanks. I got it!

Cheers bro.

That is what is quite tricky. I don’t know what all the SAC files are? And how do you know what sufficient permissions are?

Thanks.

Ok. So I should check for a plugin conflict? I would be surprised because it has worked absolutely fine until the transfer.

If it comes to file permissions, which permissions should I add and to which files please?