Hi, I can try to look into this. What we can do I think is: 1/ Move to custom mapping of the translations class - requires migrating the data - requires rewriting the queries use throughout the application This should speed up all calculations. 2/ Move counting of missing translations in it's own data set and use a scheduler job to recalculate regularly these counts - requires informing the user that data might not be fully up to date, and eventually put a button to recalculate for a specific language/project - the best contributor ranking would not necessarly need a refresh and would only need to be calculated from time to time - we can use this opportunity to display some full counts of missing translations for a country/project including a rnaking by country which is not doable right now I believe that these are the most costly operations at this point. Moving towards pre-calculated data would speed up things incredibly. If that seems ok for all I would do the following: - take the L10N app locally and setup custom mapping - rewrite the queries for both real time calculation and scheduler based calculation - migrate L10N by taking it offline half a day - create the new classes to hold the pre-calculated data - implement the scheduler job to preform the calculation and save to the new classes - implement the queries to display calculations from the pre-calculated data - add some new queries to get a full language ranking WDYT ? Ludovic 2013/1/18 Vincent Massol <[email protected]>
Cool, thanks Ludovic!
Now we just need to fix the speed and reboots on L10N and we're good :)
-Vincent
On Jan 17, 2013, at 11:13 PM, Ludovic Dubost <[email protected]> wrote:
Hi,
I've done some improvements on L10N to allow to have a status of the Platform/XE/XEM translations by language.
The supported language panel now points to this page:
http://l10n.xwiki.org/xwiki/bin/view/L10N/StatusByLanguage?language=fr
which shows how many missing translations we have for each bundle of Platform/XE/XEM.
Note that the first time this page is called for a language it is a bit slow, then the data is saved in cache until there is a new translation added. You need to be logged in to see the data.
Ludovic
_______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
-- Ludovic Dubost Founder and CEO Blog: http://blog.ludovic.org/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost