Background of the issue:
I am trying to optimize our site's performance and noticed a slow query from WPML's Media Translations feature while using MySQL slow query logging on RDS. The query is consistently flagged for performance issues. Running this query on our staging server results in a timing of 7.6 seconds. I explored potential improvements such as query result caching, improved indices, and replacing the JOIN-based query with a nested WHERE statement, which reduced the time to ~1.9 seconds.
Symptoms:
The SQL query executed by WPML Media Translations has a large performance overhead, taking 7.6 seconds to run and examining around 890k rows.
Questions:
How can I optimize the performance of WPML Media Translations SQL queries?
Can you work on optimizing WPML performance for larger sites?
I checked with our devs and there isn't much we can do without access to a copy of your website.
"We need the means of reproducing this issue. I am not aware which action exactly is doing this request.
Debugging performance issues requires at the least minimum the steps and an environment or idea of such an environment that this can be reproduced in.
So first tell me the exact steps that I can try so that I can even start tracing this, then a Duplicator will be best solution - as it is possible that either custom code or something from a 3rd party plugin is triggering this.
By "an idea of such an environment" I mean - list of possible plugins, custom code and/or themes along with number of contents.
Yes the number of contents in a mysql table play a pivotal role and a query which executes normally for 0.0001sec on a clean environment may execute for a second on an environment with a milion rows or so. It all depends on the SQL query."
As I said, you can remove any sensitive information from the copy, if you prefer. Without seeing the issue, we likely cannot fix it.
The topic ‘[Closed] WPML Media Translations runs SQL queries with a large performance overhead’ is closed to new replies.
Manage Cookie Consent
We use cookies to optimize our website and services. Your consent allows us to process data such as browsing behavior. Not consenting may affect some features.
Functional
Always active
Required for our website to operate and communicate correctly.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
We use these to analyze the statistics of our site. Collected information is completely anonymous.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
These cookies track your browsing to provide ads relevant to you.
