The example below demonstrates the use of the MySQL CASE statement to cleverly construct a bulk update statement. A huge performance boost over performing individual…
Mod Rewrite w/ HTTP Authentication
Putting a site behind HTTP Authentication is a pretty simple task, but when your site is being served by another application server – let's say…
Make those SQL queries chunky
I'm by no means saying that my tests below are evidence enough to support the case for "chunky" SQL queries. By chunky, I mean queries…
Encoding videos programatically
A free library called FFMpeg makes this possible for us. If you wish to encode to MP4, you'll need the help of the following additional…
Page specific CSS
One major decision when it comes to performance optimizing your site is how to merge your CSS files, if at all. Let's say that you…
Bulk inserts to reduce trips to database
By combining multiple inserts into one bulk insert statement, you can reduce the total number of statements sent to the database, speeding up combined execution…
Browser caching in 60 seconds
There are a multitude of articles out there on browser caching. If you're using Apache as your web server and want to cut to the…