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

Posted in MySQL, Programming | 1 Comment

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

Posted in Restaurants/Pubs | 1 Comment

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

Posted in Football | 1 Comment

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

Posted in Motorbikes | 1 Comment

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

Posted in Restaurants/Pubs | 1 Comment

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

Posted in Motorbikes | 2 Comments

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

Posted in MySQL, Programming | Leave a comment

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

Posted in MySQL | 1 Comment

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

Posted in Motorbikes | 3 Comments

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

Posted in Programming | Leave a comment