Don't rely on automatic type conversion
This will only yield a tiny speed boost, but every little helps. If you declare a field as having an Age field of type INT, this query is in fact valid:
UPDATE table SET Age = "1"
The query states that Age should be set to the string value "1", not the number 1. However, MySQL will recognise that Age should be an integer, and automatically convert the string "1" to the integer 1 before updating the table. This type conversion is indeed very helpful, but, as we already knew that Age was going to be an integer, we could have saved MySQL some pointless work and not used the quotes.
Next chapter: Benchmark, benchmark, benchmark! >>
Lock your tables when appropriate
Performance Optimising your code Write your code sensibly Use your tools wisely Use some functions carefully for maximum performance Use the Zend Optimizer for older PHP versions Use a PHP code cache for newer PHP versions Read the manual carefully Get your loops right first Pre-increment and post-increment aren't the same Don't think that using references will lower your RAM usage Be wary of garbage collection, part 1 Be wary of garbage collection, part 2 Listen to all errors, big and small Keep up to date Cache array data Compress your output Don't use CGI Don't use dl() Debug your code Cache your data with memcache Use persistent connections Take advantage of new features Compile right Ignore the myths Avoid mod_access if you can Make sure you optimize Apache Optimising your SQL Prioritise your data Optimise your tables Select as little data as possible Use shorter queries where possible Use the EXPLAIN statement Change your hardware Choose your data types carefully Size vs. Speed Declare fields NOT NULL Load data intelligently Consider splitting off variable-length fields Be wary of locks Consider switching OS Spot slow queries Perform joins carefully Index your data Make sure your indexes are being used Normalisation Upgrade MySQL Increase your buffers Keep tabs on your server Lock your tables when appropriate Don't rely on automatic type conversion Benchmark, benchmark, benchmark! Know MySQL's strengths Server PHP Accelerators Caching PHP PHP as a CGI or a module? Size of scripts Summary Exercises Further reading Next chapter
Table of Contents
Copyright ©2015 Paul Hudson.
Follow me: @twostraws.