On 16.02.2011 20:26, Mark Phippard wrote:
> 2011/2/16 Branko Čibej <brane_at_e-reka.si>:
>
>> My not very humble opinion -- we can play silly buggers trying to
>> optimize this bit of the query, but effort would be better spent in
>> merging NODES and ACTUAL_NODE, which in turn would allow us to drop the
>> second query altogether and halve the total time needed to populate the
>> cache table.
> Are you interested in doing this and just seeing if there are objections?
>
> You have brought it up a couple times and no one is responding. If
> you think there might be objections maybe it needs a new thread? If
> it delivers a performance win then I think we should do it. I do not
> think null column values are going to waste enough disk space to be a
> concern.
I'd love to, but that would be biting off more than I have time to chew
on right now. Yes, I know that throwing suggestions (and patches) over
the wall is not very constructive, but that's the best I can do in my
copious free time.
-- Brane
Received on 2011-02-16 20:36:00 CET