Comment 4 for bug 241394

Hi Ursula, thanks for cleaning up the status here.

However, I'm lowering priority on this one, and I'll explain why: this bug is not about actual performance issues we have in LP Translations (for historical perspective, you may want to look at bug 30602). It's about a single test that was made during a time when it was essential to keep the number of queries down under a certain fixed threshold (we have since done a lot of DB redesign, improving performance, and then later we got flashy new hardware as well). Basically, a test was just made to fail if we inadvertently mess up. It had to be disabled because Storm migration brought some changes in the query count, and we didn't feel it important enough to fix right away.

I've looked through a few latest Edge and Lpnet OOPS reports, and it seems we are only triggering SoftTimeouts. Around a year ago we regularly got around a few thousand hard timeouts on +translate pages every day, and getting a few of them these days is a relatively positive outcome: we are not yet ready to consider soft timeouts a real problem. However, note that we are doing some more work to improve our performance further, but a "bug" about that might be slightly ill-placed (i.e. this is something that's really hard to quantify, especially with the amount of data we have, and Translations team). To see details about it, check https://blueprints.edge.launchpad.net/rosetta/+spec/message-sharing

And other things are happening as well (i.e. we are introducing DB replication as well, which will help with this problem too).

I hope this clarifies some bits here.