News for hackers. Stuff that matters.
Re:Stack Overflow Makes Slow Pages 100x Faster By Simple SQL... by jacques_chester on Tuesday May 03, 2011 @06:43PM (#2511953)
With one exception: joining over database links is terrible. I admit that it's a hard problem to solve, but still.

Just yesterday I rewrote a view that used a database link to act as a materialized view (which makes me feel icky). It ran approximately 10,000 times faster. For a 100-row result that only joins 4 modest tables, there shouldn't be that kind of a difference IMO.

There are no comments on this comment yet.