Monthly Archives: September 2004
MySQL Truncate slow performance problems
I was having problems with a MySQL TRUNCATE taking a long time on a very large table (with foreign keys). I had thought that TRUNCATE ran more quickly than DELETE but, according to the MySQL manual, that isn’t the case … Continue reading
Restaurant review: Vic Naylor’s, Clerkenwell, London
Vic Naylor’s in Clerkenwell is one of a collection of reasonably up-market restaurants along St John Street. On entering the bar/restaurant one is struck by the effort that has been put into the interior, yet somehow it appears very natural. … Continue reading
Fantasy football league team
We’re at second in an office Telegraph’s fantasy football league at the moment, which is pretty good, but one of the directors is in the lead and apparently has won for the past two years. Our fantasy football team consists … Continue reading
Review of Yamaha Fazer FZ6 600
Having not ridden a motorbike for some 7 years I sat astride the Yamaha Fazer 600 with some trepidation. I had chosen the bike as it looked like it would have a reasonable amount of power to ‘break me in’ … Continue reading
Restaurant and pub review: The Duke of York, Clerkenwell
“The Duke” in Clerkenwell is hidden away down a back street (Roger Street) just off Theobalds Road and Grays Inn Road, London. Although the pub comes across as a ‘local boozer’, it’s clear from the thought that’s been put into … Continue reading
Honda VFR 800 review
I’ve ridden a few bikes over the past couple of years including a Yamaha Fazer 600, a Honda CB 500 and a CBR 600 (a few times now). I was really looking forward to trying out the VFR as I … Continue reading
Implementing Iterator in PHP 5
There’s a good article on sharepoint about implementing Iterator in PHP 5: http://www.sitepoint.com/article/php5-standard-library/1. I’ve used it a couple of times now and it’s a great way to treat objects as collections. More info about the Standard PHP Library can be … Continue reading
MySQL load data infile and foreign key constraints
I’ve been up against a(nother) MySQL 4/PHP 5 ‘not doing all I want it to’ type problem. This time, it involved trying to do a bulk update on potentially tens of thousands of lines. Now, I don’t want to do … Continue reading
Motorbike hire in east London
I usually hire motorbikes from a place called Raceways in Surrey Quays, East London but a) it’s quite expensive, and b) they’re the wrong side of the river. I’m going to be on a Honda VFR800 this weekend I’d definitely … Continue reading
Hiring an ASP.Net developer
My company is looking for an ASP.Net developer, so here seems as good a place as any to put an ad. Job description below: London based Internet development company seeks permanent ASP.NET developer with an absolute minimum of 1.5 years … Continue reading
