On Wed, Feb 16, 2011 at 02:26:51PM -0500, Mark Phippard wrote: > 2011/2/16 Branko Čibej <br...@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.
+1