449249 - Verify the units table is useful and not slower than necessary

Status: RESOLVED WONTFIX

(Webtools Graveyard :: Verbatim, defect)

Description

[Wil Clouser [:clouserw]]

The units table is already pretty big with only the default projects.  We should make sure it's not needlessly so.  From IRC:

10:27 <@clouserw> question:  what is the units table and why is it so giant?
10:28 <dschafer> that is a table with every "english" -> "not english" translation in any project in any language
10:28 <dschafer> it's used by statsdb
10:28 <dschafer> and that is all it is used by
10:29 <@clouserw> so, statsdb loads the .po files and puts them into this huge table?
10:29 <dschafer> something like that, yes.... :-/
10:30 <@clouserw> I don't understand what use the table is.  it reloads the .po files each time so it can get the latest stats, right?
10:32 <dschafer> i'm not sure; i didn't touch the statsdb logic at all, just converted it to MySQL syntax
10:33 <@clouserw> ok

Comment 1

[Fred Wenzel [:wenzel]]

Closing out Pootle bugs from Verbatim component:

We're running Pootle trunk, and it's not a feature to be implemented on our end, but this might already be fixed.