[wp-meta] [Making WordPress.org] #3397: Translate: Plugins listed on Waiting filter not part of general Plugins list

[Making WordPress.org]

#3397: Translate: Plugins listed on Waiting filter not part of general Plugins
list
--------------------------------------+------------------
 Reporter:  garrett-eclipse           |       Owner:
     Type:  defect                    |      Status:  new
 Priority:  normal                    |   Milestone:
Component:  Translate Site & Plugins  |  Resolution:
 Keywords:                            |
--------------------------------------+------------------

Comment (by dd32):

 Replying to [comment:5 garrett-eclipse]:
 > Thanks @dd32 I appreciate you looking into this.
 > Would it make sense to open a ticket with GlotPress to prompt a revisit
 on the GlotPress handling of data in these cases?

 Nah, there's nothing wrong with how GlotPress is storing data, it's just
 that you can't sort/filter by these kind of data points with any ease when
 you have 90k Projects with 170 languages (inc variants) providing 5
 million original strings and 50 million translations :)

 Unfortunately that all actually means our summary table has ended up at
 14million rows too (90k Projects x 170 languages) which affects query
 performance as well.
 We probably need to re-do our summary table to account for inactive
 projects (ie. so that if Plugin A in language X has no activity, it's not
 in the summary table affecting performance of other queries)

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