WordPress.org

Making WordPress.org

Opened 8 months ago

Last modified 3 months ago

#3155 new enhancement

Move number of waiting strings from /stats to /locale/slug/default

Reported by: tobifjellner Owned by:
Milestone: Priority: low
Component: Translate Site & Plugins Keywords:
Cc:

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.

Change History (13)

#1 @ocean90
8 months ago

  • Priority changed from normal to low

We can’t add caching to something if the query itself times out. This also only affects waiting strings for all plugins and themes. The waiting strings for the main projects are still displayed.

#2 @tobifjellner
8 months ago

In that case we should delete the current columnn with "total waiting strings". As it stands now, it presents stale data that to some extent was incorrect from the start.

And adding this information per locale on the page for each locale shouldn't really time out, since you'll be traversing the data only for one locale.
After all, part of that information is anyway gathered in order to build https://translate.wordpress.org/locale/slug/default
Number of projects is used for pagination. Number of waiting strings is presented per project and is used for sorting. We'd just need to present this piece of information. It could, for example, be added next to the breadcrumb, as "Locales / Swedish / Waiting (3168 strings in 92 projects)"

This ticket was mentioned in Slack in #polyglots by tobifjellner. View the logs.


8 months ago

#4 @xavivars
8 months ago

In the case of Catalan, data is not only stale, but incorrect. Last time I checked (July/August), there were +10k waiting strings (I moved it down from 15k to 10k during the summer). So clearly 12 strings is incorrect :)

#5 @jyourstone
8 months ago

Seconding this, having the amount of waiting strings displayed is very useful for GTE's to see progress.

Last edited 8 months ago by jyourstone (previous) (diff)

This ticket was mentioned in Slack in #polyglots-events by tobifjellner. View the logs.


8 months ago

This ticket was mentioned in Slack in #polyglots by sergey. View the logs.


8 months ago

#8 @Mte90
8 months ago

This page for the GWTD will be very helpful we need to track what will happen on that day...

This ticket was mentioned in Slack in #meta-i18n by mte90. View the logs.


8 months ago

This ticket was mentioned in Slack in #polyglots by nao. View the logs.


8 months ago

This ticket was mentioned in Slack in #polyglots by coachbirgit. View the logs.


8 months ago

This ticket was mentioned in Slack in #polyglots by tobifjellner. View the logs.


5 months ago

This ticket was mentioned in Slack in #polyglots by tobifjellner. View the logs.


3 months ago

Note: See TracTickets for help on using tickets.