News for hackers. Stuff that matters.
Re:Stack Overflow Makes Slow Pages 100x Faster By Simple SQL... by electrum on Tuesday May 03, 2011 @01:34PM (#2510885)
10 years ago ... MySQL

MySQL could barely do joins ten years ago. Today, it's still behind where Oracle was ten years ago. You can throw extremely complicated queries at Oracle and it generally optimizes them well. Don't think of MySQL as "fast and highly optimized". It's only fast for relatively simple queries.

When I say complicated queries, I'm talking about 50+ line queries with many joins, subqueries, aggregations, etc. You can run these against tables with millions of rows and still get an answer in seconds, often regardless of indexes.

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.