WordPress is a insanely popular blogging platform, and with every release it gets better. It’s also very easy to install, even for those who have never installed a CMS on their server before. The first step is to head over to WordPress.org and download the WordPress file. Click on the Download button on the top [...]
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.
Have you ever spent way too much time looking for a solution to a problem? Ever felt like smacking yourself in the head when you finally found the fix? Well today I spent about half an hour trying to find out why a MySQL INSERT query wasn’t working. I was working on a logging table [...]
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 [...]
One of the really great, although probably overlooked by most users, features of WordPress is that you can store meta data on your users. You probably already know that you can do this for posts, but it’s possible to use the _usermeta table to keep track of custom user settings as well.