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.
[ Parent
| on HN ]
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.