On 13/01/07, Domas Mituzas midom.lists@gmail.com wrote:
I hate just chronic whiners, who start calling you idiot after you misspell their name or leave weeping after minor criticism, but to not limit criticism they emit themselves. I do not have issues with other people ;-)
I called you an idiot because I had run out of options - you were, in fact, being remarkably insulting, which is amazingly difficult to do or so I'm told.
I don't know where this "leave weeping" nonsense comes from, to be frank - I chose to go on a break in August for my sanity and for the sanity of others. It did me the world of good and I've pledged to keep taking more time off this thing. We obviously have an irrevocably broken working relationship, which is extremely sad, because I respect your database knowledge, but I have to point out that it wasn't I who cast the stone to break it.
To stay on topic - we might want eventually to put covering index for all contributions-based operations, but still, for this operation we may want to keep a separate table (and do that for most queries, that need aggregation). For different traversing methods covering indexes are way to go.
I haven't questioned the necessity of optimising the extension and agree that a separate table is probably the best approach.
Rob Church