How to add a timer to Eventum

I’ve been using Eventum for a while to keep track of bugs in a web application of mine. There was one feature missing that I really needed, and which made me switch to dotProject for a few months and that was a timer. When I’m working on a bug I wanted a way [...]

How to install WordPress 2.5.1

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 [...]

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.

Sometimes I just frustrate myself

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 [...]

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 [...]