Database growing and queries are slow
-
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
FROMovb_trp_dictionary_en_us_el
WHERE status != 0
ANDoriginal!= ‘<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%” 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
The topic ‘Database growing and queries are slow’ is closed to new replies.