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.
addthis_url = ‘http%3A%2F%2Fforumsblogswikis.com%2F2008%2F06%2F12%2Fsql_calc_found_rows-is-it-faster%2F’;
addthis_title = ‘SQL_CALC_FOUND_ROWS+-+Is+it+faster%3F’;
addthis_pub = ‘RyanNutt’;
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 [...]
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 [...]
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 sake, [...]
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.
addthis_url = ‘http%3A%2F%2Fforumsblogswikis.com%2F2007%2F06%2F12%2Fscript-for-benchmarking-php-functions%2F’;
addthis_title = ‘Script+for+benchmarking+PHP+functions’;
addthis_pub = [...]