A Renewed Passion For Design And Development

At the close of last week’s post I mentioned that working on a new site for myself has reinvigorated a little of the old passion for design and development. While I was very hesitant to start working on the site again, I’ve had a lot more fun than I expected since I’ve been writing code.

Continue reading

The Growing Complexity Of Developing Websites and the Growing Ease Of Using Site Builders

Last week I talked about how I’ve been stalling and stalling and stalling when it comes to building a new site about writing and creativity. I also told you how the time had finally come where I couldn’t avoid it anymore and I’ve been surprised to find I’m enjoying myself more than expected.

Continue reading

Review—About Design: Insights and Provocations for Graphic Design Enthusiasts

I often talk about the importance of context and how it helps set the tone for everything that follows. It also helps you integrate new understanding of specific details into a greater whole. When I approach a new subject, I like to start with a general overview in order to provide context for the rest of my learning. This method of study helps me see new material through an established perspective and it helps me form a point of view about the subject.

Continue reading

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