Comment 4 for bug 608037

I think the queue is fast. We send an email to every direct and indirect subscriber, and in the case of Ubuntu, that is 1000 of emails for every message or modification. I think part of the issues is that Answers is a successful application--we ignore it, it's user base grows, and it gets few bug reports. I think we we are seeing scaling issues that were not visible 3 years ago.

I think the iteration mechanism to expand emails to teams is slow. This is a common problem in launchpad. If we could build a notificationrecipientset is a single query to learn direct and indirect subscribers that also expands team subscriptions to individual users when needed, we could dramatically reduce the SQL query count. We mail also dramtatically increase the the SQL time though