SQL_CALC_FOUND_ROWS – Is it faster?
Reading through a post on SQL_CALC_FOUND_ROWS actually being slower that running one query followed by a count query I decided I needed to do a little benchmarking on my own.
phpSpeedy claims seem exaggerated
A web buddy of mine sent me a link to phpSpeedy via StumbleUpon, and asked me what I thought of it. It seems like a good idea for a topic, and a waste if I just replied in email, so I figured I’d write my thoughts here. What phpSpeedy claims is that it speeds up [...]
Comparing MySQL search speed for different column types
Starting work on a new website I wanted to know which type of MySQL column was the fastest to search on. I assume it’s a numeric column, but I really want to know how much of a difference it makes. What I’m working on right now is an options table and it would be a [...]
Benchmarking single vs. double quotes in PHP
PHP allows you to define a string using either a single quote (’) or a double quote (”). Why? Is one better? Faster? Why should you use one over the other. In this article, I am going to benchmark both methods; both with literal strings and strings with variables included. As an aside for completeness [...]
Script for benchmarking PHP functions
Often I find myself needing to know which way of performing a task in PHP is the fastest. The code below let’s you easily test snippets of code to see how long it takes to run.