re: You Can Do it in SQL, Stop Writing Extra Code for it VIEW POST

re: I like your point of view, databases are not easily scalable that's where managed services with load balancers come into play I suppose. About the ...

6ms is with zero caching, that's all live database queries and html template processing.

The query in question about the SQL optimizer is the one with the HAVING statement. I'd have to check, but limiting the number of rows in a HAVING statement based on an IF statement in the column selector I believe requires a full table scan. The GROUP BY statements should all be good though, especially considering the advances in optimizing these in the past two years.

Sounds interesting for 6 ms.

For the having query it was just an elaborated example, if it was a real DB query I would have surely run an explain to see if that is the way to go. Thanks!

code of conduct - report abuse