News for hackers. Stuff that matters.
Re:Learn SQL, dammit by rheide on Wednesday May 08, 2013 @02:52PM (#5676089)
No. First, learn the internals of your system. Learn SQL. Learn NoSQL. Understand why your software is slow. Then, once you've optimized the worst case away with decent SQL and/or a good object-oriented architecture. Then and only then should you start with caching. Too many developers these days are just brainless monkeys who dump everything in memcache.
Re:Learn SQL, dammit by jeffasinger on Wednesday May 08, 2013 @03:30PM (#5676309)
A coworker mentioned to me that she came in early every day so she could run a report that took about an hour and a half before the CEO got in.

I looked at the code, nothing looked THAT bad, so I did an EXPLAIN, noticed a missing index, added it. I ran the report in 4 minutes.

Clearly, whoever wrote that report didn't know nearly enough about SQL.