Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #78239
    Padmaraj Madatha
    Guest

    HI,
    We have a pro version of W3 total cache. Recently we enabled WPML on our site. After doing that we noticed that addition translation queries of WPML are adding load on our database. we were expecting these queries to be cached. We could not find an option to enable it either. Can you please help us? Sample query:
    SELECT wpml_translations.translation_id, wpml_translations.language_code, wpml_translations.element_id, wpml_translations.source_language_code, wpml_translations.element_type, NULLIF(wpml_translations.source_language_code, ”) IS NULL AS original , tm.name, tm.term_id, COUNT(tr.object_id) AS instances
    FROM abc_icl_translations wpml_translations
    LEFT JOIN abc_term_taxonomy tt
    ON wpml_translations.element_id=tt.term_taxonomy_id
    LEFT JOIN abc_terms tm
    ON tt.term_id = tm.term_id
    LEFT JOIN abc_term_relationships tr
    ON tr.term_taxonomy_id=tt.term_taxonomy_id
    WHERE 1
    AND wpml_translations.trid=27012333666513139
    GROUP BY tm.term_id

    Thanks

    #78499
    Marko Vasiljevic
    Keymaster

    Hello,

    Thank you for reaching out and I am happy to assist you with this.
    Can you please share if the Object Caching is enabled in W3 Total Cache and if so which caching method you are using for Object Caching?
    Have you also checked with the WPML if those queries are deliberately prevented from being cached?
    Thanks!

    #78541
    Padmaraj Madatha
    Guest

    Yes, we have object cache enabled. we are using Redi. We are also trying to reach out to WPML. But wanted to check with you if you someone else reported similar issue and if there is something we are missing in our configuration.

Viewing 3 posts - 1 through 3 (of 3 total)
  • The topic ‘wpml translations queries not cached’ is closed to new replies.