• Resolved almis90

    (@almis90)


    Hello,

    I have an issue on my server where siteground complaints that a query takes a lot of resource to run. The query is from this plugin

    SELECT original, translated, status 
    FROM ovb_trp_dictionary_en_us_el 
    WHERE status != 0 
    AND original != ‘<REDACTED_URL>’ 
    AND MATCH(original) AGAINST (‘<REDACTED_URL>’ IN NATURAL LANGUAGE MODE ) 
    LIMIT 1;

    I have removed the url, it start like this: “https://outlook.live.com/owa?path=%2Fcalendar%2Faction%2Fcompose&rru=addsubscription&url=webcal%&#8221; but why it even tries to translates these url.

    I have disabled dynamic translation, removed these urls from database also run the database optimization tool it helped me to reduce the data but the next day same happened.

    Is there a way to only keep the data that I have translated? Remove all the rest and do not try to generate it again?

    Thanks

Viewing 1 replies (of 1 total)
  • Hey there,

    Thanks for reaching out to us!

    The problem you are experiencing seems to be related to the “Automatic Translation Memory”. Please go to TranslatePress Settings => Advanced => Miscellaneous options and deactivate it.

    Let me know if it helps.

Viewing 1 replies (of 1 total)

The topic ‘Database growing and queries are slow’ is closed to new replies.