How to estimate the cost of translation using the translator plugin

Product Support
5

Thanks for this guide. I have two questions:

  • based on this:

    It might be nice to still correlate the data from the users.locale field and get a % of users who have it set to non-english value (if your site doesn’t automatically adapt based on the user environment, which I think is an option in admin settings)

  • did you notice a significant spike when you first launched the plugin based on this?
    image

    I believe something like this could still be added to complete the estimation:

    SELECT  LENGTH(COALESCE(string_agg(posts.cooked, ''),''))
FROM    posts
JOIN    topics on posts.topic_id = topics.id
WHERE   topics.archetype <> 'private_message'