“Balancing performance and memory footprint is crucial to writing good software.” Link: Writing Efficient Queries at codeship

Instead of procrastinating for “will-refactor-later,” I started using a few simple rules that helps me create consistently high-quality code. Remember, good code lets you focus on additional performance-tuning whenever it’s necessary without worrying about your code.

And feel free to talk about how you improve performance and queries!