[wp-meta] [Making WordPress.org] #3155: Add total number of waiting strings within a locale from /locale/slug/default (was: Move number of waiting strings from /stats to /locale/slug/default)

[Making WordPress.org]

#3155: Add total number of waiting strings within a locale from
/locale/slug/default
--------------------------------------+---------------------
 Reporter:  tobifjellner              |       Owner:  (none)
     Type:  enhancement               |      Status:  new
 Priority:  normal                    |   Milestone:
Component:  Translate Site & Plugins  |  Resolution:
 Keywords:                            |
--------------------------------------+---------------------
Changes (by tobifjellner):

 * priority:  low => normal


Old description:

> [5955] froze the number of waiting strings for each locale, since the
> query for count of waiting strings in each language used to time out.
> At the same time, partial results seems to cached, so if I reloaded
> https://translate.wordpress.org/stats a couple of times, I'd usually get
> all (or most) counts correctly.
>
> But yes, /stats was slow.
> However, this piece of information is important. First of all for the
> GTE's of each locale.
> I suggest that the total number of waiting strings '''for a specific
> locale''' is added to https://translate.wordpress.org/locale/slug/default
> ''(where slug is replaced by the locale slug)''
>
> For overview, it would be good to still present these numbers on /stats
> but using cached values for total waiting strings per locale and update
> this cache via a cronjob once an hour.

New description:

 [5955] froze the number of waiting strings for each locale, since the
 query for count of waiting strings in each language used to time out.
 At the same time, partial results seems to cached, so if I reloaded
 Earlier https://translate.wordpress.org/stats was showing (or trying to
 show, the query timed out all the time) the total number of waiting
 strings per locale.

 However, this piece of information is important. First of all for the
 GTE's of each locale.
 I suggest that the total number of waiting strings '''for a specific
 locale''' is added to https://translate.wordpress.org/locale/slug/default
 ''(where slug is replaced by the locale slug)''

 Since I hope the count of waiting strings for only ONE locale is a much
 smaller effort than gathering the same for ALL locales, this should be
 doable. After all: in order to show correct pagination for the page with
 waiting projects, a query is already run on that page, to gather all
 projects with waiting strings and even sort them in descending order by
 number waiting strings.)

 (Updated description on Jan 16 2019 - and reverted prio to Normal)

--

-- 
Ticket URL: <https://meta.trac.wordpress.org/ticket/3155#comment:16>
Making WordPress.org <https://meta.trac.wordpress.org/>
Making WordPress.org