• Resolved chrismask

    (@chrismask)


    So, after some days of debugging I found out why the second language page is always very slower. Apart from object cache having great problems, that I fixed. Now i found out this plugin is seriously badly written. How can you not give us the option to stop bloating the database with every possible string generated by the server? My dictionary and original strings tables are over 100MB while the (almost) only needed gettext table is 2MB. The dictionary and the original strings tables are like 80% full of links and 10% of useless strings that are never going to be translated by anyone. (Who even translates links and why would you bloat all our databases for this dumb feature in the first place). At least give us the option to stop generating hundreds of strings every minute. I had tried to delete all links and useless strings in the database, and later found out that almost all came back after a simple clearing and preloading of cache. At least give us a hook or a developer option. I have put all possible strings and links regexes in the current options and nothing works.

    • This topic was modified 1 year, 9 months ago by chrismask.
    • This topic was modified 1 year, 9 months ago by chrismask.
    • This topic was modified 1 year, 9 months ago by chrismask.
Viewing 12 replies - 1 through 12 (of 12 total)
  • Plugin Support Anghel Emanuel

    (@anghelemanuel99)

    Hello there,

    Thank you for letting us know about this!

    If you are referring to external links that are in the database, you can exclude the domain and see if this could help you:https://translatepress.com/docs/developers/excluding-translation-of-external-domain-links/

    Try this and let me know!

    Kind Regards,

    Thread Starter chrismask

    (@chrismask)

    I am referring to all links. Of course I have put there all domains that get generated, doesn’t work at all. But my issue is not this. I just want the translation to stop. I have translated everything I wanted. Why isn’t there an option to stop putting all strings in the database, in the first place? At least give me a hook or the function this takes place so I deactivate it.

    Hello,

    I have the same issue. TRP can become crazy and translate, as well as the backend or even the translate interface. I added */wp-admin/* and the path of the translation interface, to limit it. But I’m not 100% confident. My database is also full of links, and titles with an incremental number. This plugin is full of defaults; it’s the same because it could be the best without these troubles. The last update 2.4.6 is creating a lot of timeouts and 404 errors.

    The TRP support failed in this case.

    Thread Starter chrismask

    (@chrismask)

    I have tried putting domains like https://www.google/*, my site, even https://* or whatever, tried /wp-content/ to stop generating infinite image links (like who even translates image url?) and doesnt work at all. A simple option to stop filling the dictionary and originalstrings table would be very good.

    1. Stop new translations
    2. Dont translate links
    3. Dont translate images
    4. Cleanup database from useless content.

    At least the 1 is mandatory and shall be implemented soon, at least give us a hook or tell us the function in which all these strings are generated.

    Also, a good addition would be to stop looking at dictionaries and original strings enormous tables on page generation time, that searches all this enourmous dictionary table and loads the translation that matches. This makes each page slower without good reason. Why wouldnt this plugin be simpler since 90% of people that use it, do it just to translate gettext strings, and use the language switcher. I just want only these and not a hundred more useless features that make every page slower.

    • This reply was modified 1 year, 9 months ago by chrismask.
    • This reply was modified 1 year, 9 months ago by chrismask.
    Thread Starter chrismask

    (@chrismask)

    Are you going to fix it or suggest a way so i can fix it? At least give me the functions where these operations happen, I am a premium paying user.

    Plugin Support Anghel Emanuel

    (@anghelemanuel99)

    Hello there,

    Do you use automatic translation?

    If yes,that`s why new translations appear on your website so you can disable it.

    Also,if you have more problems,you can open a ticket here:https://translatepress.com/support/open-ticket/ and mention this conversation in it.

    Kind Regards,

    Thread Starter chrismask

    (@chrismask)

    Can the developers answer this topic? I have told you I have tested all possible advanced options, have gone through all documentation and searched all google, and at the same time I had automatic translation on? I am saying every string generated by site and even server (even open:atom urls are generated and i only use atom on filezilla) goes to original_strings and dictionary table and they have bloated completely the database with 95% of them being useless urls and image urls, this has nothing to do with translation apis, and of course i have it disabled.

    • This reply was modified 1 year, 9 months ago by chrismask.
    Plugin Support Alex

    (@alexcozmoslabs)

    @chrismask

    Regarding the custom code, my colleague suggested, it works for the dynamically generated links. Those dynamic links are basically JS-touched links, changed through JS. This means the code is not applicable for server-side links, the ones you insert manually when you create a post in the back-end for example (for this you need to use data-no-transaltion attribute, for example <a href=”facebook.com” data-no-translation-href>My link</a>).

    As mentioned in the documentation, the external links are detected for the possibility of changing the URL in a different language. We had a lot of users requesting this in the past, as well as image translation, so those were implemented.

    Also, the code that stops the dynamic links translation doesn’t delete the old entries from the database (these need to be manually deleted by you). it will stop only the new ones.

    The increased loading speed may be due to a lot of JS content. We have a listener for Javascript strings that when it detects a text change on the page (say a particular JS script adds a notice), we query the server for a translation. This ajax call is also fast as it doesn’t go through the normal WordPress ajax, however, it can be run intensively when there is a lot of traffic to your website. The good part is that you can disable this functionality from TranslatePress -> Settings -> Advanced tab.
    Another possibility is to have duplicate entries in your database which might affect your loading speed. You can use the Remove duplicate rows option from TP Settings –> Advanced tab to clear them and you should see improvements.

    Now, regarding your suggestions for improvement, our dev team will review them. However, the way WordPress environment works make it pretty difficult to separate different type of content, for example, to not detect a string at all if it has a link behind it. This may lead to wrong detection of the desired content which will cause other problems that are difficult to control.

    Thread Starter chrismask

    (@chrismask)

    I know about this data-no-transaltion thing, I didnt really understand if it was a joke or something, of course I am not going to put data-no-transaltion in all thousand urls or image urls that the site has, it may break things, hurt seo or whatever.

    As mentioned in the documentation, the external links are detected for the possibility of changing the URL in a different language. We had a lot of users requesting this in the past, as well as image translation, so those were implemented.

    So you ruined your plugin speed and didnt even think about an option of opting out of these, for the 0.1% of usage of translation, which is for images and external urls?

    Another possibility is to have duplicate entries in your database which might affect your loading speed. You can use the Remove duplicate rows option from TP Settings –> Advanced tab to clear them and you should see improvements.

    I have used this on staging site, several times, and it always has problems. It starts and never actually ends, of course I am not going to use it on production site. Also, i dont mind deleting all useless strings from database, I mind having them generated again after 10 minutes or something, as it has already happened.

    The increased loading speed may be due to a lot of JS content. We have a listener for Javascript strings that when it detects a text change on the page (say a particular JS script adds a notice), we query the server for a translation. This ajax call is also fast as it doesn’t go through the normal WordPress ajax, however, it can be run intensively when there is a lot of traffic to your website. The good part is that you can disable this functionality from TranslatePress -> Settings -> Advanced tab.

    I have told you many times, I am talking about TTFB or the time the server is generating the html document to send to the browser, on uncached pages, which is a lot due to the translatepress plugin. This has nothing to do with my javascript files and I have optimized them in any case. About the script you say, is it only for detecting changes on strings, or is it needed for fetching already translated strings from trp tables? Is it trp-translate-dom-changes.js? Update: This option disables dynamic tranlsation completely, even translated strings dont work. I just want to disable bloating the database.

    Now, regarding your suggestions for improvement, our dev team will review them. However, the way WordPress environment works make it pretty difficult to separate different type of content, for example, to not detect a string at all if it has a link behind it. This may lead to wrong detection of the desired content which will cause other problems that are difficult to control. Okay, just create an option not to generate any new translation string at all. I have finished (as well as the 95% of users of this plugin) all translation and dont need all this slow functionality to run on each page, just give me the option to stop generating ALL types of new strings. If I want to continue translating, I can disable it, so simple.

    To sum up, you are unable to fix anything, just tell me the file this string generation happens.

    • This reply was modified 1 year, 9 months ago by chrismask.
    • This reply was modified 1 year, 9 months ago by chrismask.
    • This reply was modified 1 year, 9 months ago by chrismask.
    Plugin Support Alex

    (@alexcozmoslabs)

    If this still an issue? If so, please reply to this ticket or create another one on the support channel.

    Thread Starter chrismask

    (@chrismask)

    Of course it’s an issue. Just notify the developers

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘STOP translating EVERYTHING’ is closed to new replies.