On 13/01/07, Domas Mituzas <midom.lists(a)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.