Monthly Archives: October 2004

Medieval, Total War

“Medieval, Total War” is the latest drain on my time. The PC game is fantastic. A quick rundown: take control of a medieval faction and try to conquer the whole of Europe. Gameplay is like a cross between Risk and … Continue reading

Posted in Other | Leave a comment

Frankensteinway video photos

My band (Frankensteinway) is in its first music video. Not one with the highest production values, granted, but I’ve managed to get hold of a couple of screenshots: Myself (left) and Jason: Mark (left) and me:

Posted in Other | Leave a comment

Fantasy football update

A pretty good week for the team. We’ve gotten rid of Beattie and bought Roonie instead (definitely a bargain), and dumped Queudrue as he didn’t seem to be getting us many points and now Rio Ferdinand is in at the … Continue reading

Posted in Football | Leave a comment

The Gothic Temple, Landmark Trust, Stowe

Having just come back from a trip to Landmark Trust’s ‘Gothic Temple’ in Stowe I can absolutely recommend it. Staying in a temple in the middle of dozens of acres of National Trust grounds is fantastic. The temple has a … Continue reading

Posted in Other | Leave a comment

TRUNCATE TABLE on MySQL InnoDB databases

Having come up against the extremely poor performance of using TRUNCATE instead of DELETE on MySQL InnoDB tables (see previous post MySQL Truncate slow performance problems) I thought I better come up with a solution that didn’t mean leaving a … Continue reading

Posted in MySQL, Programming | 2 Comments

Multiple SQL queries using MySQL and PHP

Something that I’ve had problems with using MySQL/PHP is the limitation of only being able to run one line of SQL at a time. Using something such as Microsoft SQL Server it’s possible to write multiple lines of SQL and … Continue reading

Posted in MySQL, PHP, Programming | 3 Comments

Optimising MySQL a query with packed keys

I’ve been learning more about MySQL lately and particularly optimising SQL queries on large tables. Large, in this case, being at the moment hundreds of thousands of rows but soon to be millions. One of the problems I’ve had is … Continue reading

Posted in MySQL, Other, Programming | Leave a comment