Tips To Help You Write Faster MySQL Queries

Poorly written queries can be and often are the main reason for slow server response time. They’re a common bottleneck in the process of delivering dynamic web pages. You probably can’t make every query super fast, but you can certainly improve many, starting with those that have the slowest performance.

Continue reading

How To Find Slow SQL Queries

There are generally multiple ways to query a database for the same set of results, but some will perform better than others. As queries are often the most time consuming part of the process of delivering dynamic web pages, it makes sense to know how to find which ones are most in need of improvement and, of course, what you can do to improve them.

Continue reading

Happy Thanksgiving—Images Of My Walk Through Manhattan

Happy Thanksgiving to everyone living in the U.S. and Happy Thursday to those of you living somewhere else in the world.

Continue reading

Announcing 3 New Books On Web Design And Development

At the start of each year I write a post in which I present a few things I’d like to accomplish before I write the same post at the start of the following year. As usual I’m behind on some of what I set out to do, but I’m happy to say that at least one of my goals is nearing completion.

Continue reading

Book Review—Citizen Designer: Perspectives on Design Responsibility

A long time ago I briefly worked to help promote a political campaign. The campaign wasn’t for a candidate running for office, but rather an amendment to the state constitution or something along those lines.

Continue reading