[Closed] Website really slow after switching to multi-domain structure biggest queries are from WPML

Hello Bigul,

Thanks for the troubleshooting steps - I have already tried them all but unfortunately the cleanup doesn't help so much.

Yesterday I had the cURL errors but it seems like they were caused by the issues that your servers had the last few days.

There isn't any particularly slow queries from WPML or sitepress_cms but there are many still related with WPML :
- I have 1109 queries only from sitepress_multilingual_cms
- many duplicates too like example : WPML_Term_Query_Filter->get_terms() is ran nearly 10 times

Any other suggestions ? or questions so we can dig deeper ?
Thanks

As it is a Prod site, currently we have a strict caching mechanism that allows us to navigate as fast. But with the credentials you received - if you login to the admin, you will see the difference. Certain pages take up to 15sec sometimes.

The biggest queries are in package pages, you can navigate by clicking on any on the home page. (ie. hidden link)

Tell me if i can guide you better, or if you have any other questions.

Hello Bruno,

Let me re-explain, sorry if I was a little confusing.

While on staging, we were using the WPML setting of one domain for all 3 subsites (in the surfcamp.it/locale/... format). Once on prod, we switched to a 3-domain structure (surfcamp.it being the main domain, soulridercamp.com & surfridercamp.es).

Before the switch, we weren't observing any duplicate queries (like the ones I'm adding to this message), had half the amount of queries, and around 7-10s load times on the discussed pages. We are observing this mainly on the package pages as they are the heaviest pages we have content-wise.

Aside from all this, there are certain settings that are not staying, like "Auto sign-in and sign-out users from all domains," making me think that this is indeed an issue related to the multi-domain structure. Or translations saving in one domain and not the other while translated and published together automatically...

For us, the cache is helpful right now to display the current site when not logged in to admin, but I need to understand what is causing these issues before I can go further with some fixes I'd like to do with our translations.

Don't hesitate to reach out if you need anything. Thank you.

Hello Bruno,
Thanks for sticking with me on this - I really appreciate your patience.

I think there might be some confusion about what we're seeing here. We've already checked the database and server performance, and while yes, our pages are content-heavy, that's not what's bothering us. The real issue is that everything was working much better before we switched to the multi-domain setup.

Here's what happened: we had the same heavy pages when we were using the subdirectory structure (surfcamp.it/locale/...), and they loaded in 7-10 seconds. The moment we switched to multi-domain (surfcamp.it, soulridercamp.com, surfridercamp.es), those same pages now take 20-25 seconds with twice as many database queries.

What's really making me think this is a multi-domain issue is that we're also having other weird problems:

- The "Auto sign-in and sign-out users from all domains" setting keeps turning itself off
- When we manage to turn it on, we're technically logged into all domains, but the admin bar doesn't show up and the cache doesn't reload properly on the secondary domains
- Sometimes translations don't sync properly between domains

It feels like something isn't quite right with how the multi-domain structure is working. Is this normal? Are we missing some configuration that would help with performance? Or is there something fundamentally different about how WPML handles multi-domain setups that we should know about?

I'm just trying to understand if this is expected behavior or if there's something we can fix.

Thanks again for your help!