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 _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
