-
Recent Posts
Recent Comments
Archives
- June 2018
- March 2018
- October 2017
- August 2015
- May 2015
- February 2015
- January 2015
- December 2014
- August 2014
- July 2014
- May 2014
- March 2014
- December 2013
- November 2013
- October 2013
- September 2013
- August 2013
- January 2013
- August 2012
- December 2011
- November 2011
- March 2011
- August 2010
- February 2010
- January 2010
- June 2009
- April 2009
- March 2009
- December 2008
- November 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
- December 2006
- November 2006
- October 2006
- September 2006
- August 2006
- July 2006
- June 2006
- May 2006
- April 2006
- March 2006
- February 2006
- January 2006
- December 2005
- November 2005
- October 2005
- September 2005
- August 2005
- July 2005
- June 2005
- May 2005
- April 2005
- March 2005
- February 2005
- January 2005
- December 2004
- November 2004
- October 2004
- September 2004
Categories
Meta
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
