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
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:
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
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
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
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
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
