Comment 7 for bug 618367

The query returns 3000 rows; for all specifications in Ubuntu ever, thats not unreasonable. A quick check shows they are not duplicated.

The 30K objects come from this:
3000 rows
10 classes per row (spec, (person, email, address):drafter, (person, email, address):approver (person, email, address):assignee)

So, making storm more efficient here is probably a big win, but fairly hard to do. One thing we can do is tune the preloading stuff to not load the objects, just the ids - enough to be sure its sufficient. I'll start on this now, and separately file a bug on storm about efficient in load_object.