This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

Tagged: 

This topic contains 3 replies, has 2 voices.

Last updated by Shekhar Bhandari 5 months, 1 week ago.

Assigned support staff: Shekhar Bhandari.

Author Posts
May 13, 2019 at 1:52 pm #3799125

Lawrance

At first, one of my client's site has lots of tags, terms, posts to be translated.

In function: maybe_warm_term_id_cach[ file: wpml-term-translation.class.php ]
===
$data = $this->wpdb->get_results(...);
===

This line returned 1.3 millions records. so It's very slow to open page.

What this function used for?
Is WPML suitable for a site that has lots of tags, terms, posts to be translated?

May 14, 2019 at 7:25 am #3804273

Shekhar Bhandari
Supporter

Languages: English (English )

Timezone: Asia/Kathmandu (GMT+05:45)

Hello there,

Welcome to WPML support. I'd be assisting you further on this issue.

The function is used to cache the terms and it's translations results so that we reduce queries to the database. And yes, wpml is suitable to run on sites having has lots of tags, terms, posts without any issues.

I did a quick search in the forum and noticed a similar issue with a resolved state, the client mentioned increasing few values in the server settings helped, so could you please try to use the solution provided here to see if it helps:
https://wpml.org/fr/forums/topic/use-database-instead-of-function-maybe_warm_term_id_cache/

Further, I would like to know the versions of the plugins you are using? It's very important to know your site related information such as themes used, plugins used, PHP versions, etc. You can easily send this using Debug information settings from WPML.

So could you please go to WPML > Support > Debug Information and give me the information in the next reply. You can read the detailed instruction here: http://wpml.org/faq/provide-debug-information-faster-support/

Look forward to receiving your answers so we can get to the bottom of this issue.

Thanks

May 14, 2019 at 12:34 pm #3806773

Lawrance

Hi, I've checked your solution.
But I think, In that solution, Actually, He didn't resolve this problem. He just increased the cache size to speed up his site.

In another hand, He just has 14,719 results, But I have 1.3 million.

May 15, 2019 at 3:33 am #3811905

Shekhar Bhandari
Supporter

Languages: English (English )

Timezone: Asia/Kathmandu (GMT+05:45)

Hello there,

I agree, your issue needs further debugging to find out why it's happening. Since performance issues depend upon the site, the server, plugins used and furthermore. I would need your help to narrow down the issue. Could you please provide feedback on the following questions as much as possible?

#1
I would like to know the versions of the plugins you are using? It's very important to know your site related information such as themes used, plugins used, PHP versions, etc. You can easily send this using Debug information settings from WPML.

So could you please go to WPML > Support > Debug Information and give me the information in the next reply. You can read the detailed instruction here: http://wpml.org/faq/provide-debug-information-faster-support/

#2
Can you please review the following articles and see if all the relevant steps are covered?
https://wpml.org/faq/prevent-performance-issues-with-wpml/
https://wpml.org/2012/01/can-your-site-run-faster/

#3
Try disabling and re-enabling all WPML plugins and then going to WPML > Support > Troubleshooting and press the "Recreate ST cache tables" button.

The first visit after the re-activation of the plugins is kinda slow, but after the regeneration of the tables - it will be better.

#4
What type of hosting do you have? Shared, VPS, Dedicated, etc?

#5
Can you confirm that you are still experiencing performance issues with minimal set up (all plugins except WPML disabled and the theme on a WordPress default such as Twenty Nineteen)

Thank you for helping us pinpoint the issue. Feel free to add any further information you may have.

Look forward to your reply.

Thanks

The topic ‘[Closed] Performance problem casuses by wpml’ is closed to new replies.