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 with InnoDB tables. In this case there is no difference between TRUNCATE and DELETE and …
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. It’s also slightly more distinctive than the formulaic modern interiors that seem to be the …
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 of: Goalkeeper: J Lehmann (Arsenal) Defenders: W Bridge (Chelsea) A Cole (Arsenal) J Carragher (Liverpool) …
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’ to the world of bigger bikes, but with a less racey style than the CBR’s …
“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 the decor that it’s not intended for a purely local audience. The beer selection is …
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 thought it would offer a similar ride to the CBR 600 but with some extra …
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 found here: Standard PHP Library with a link to download a windows chm help file …
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 an INSERT for each line and I’ve already written some classes to handle outputting data …
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 be interested in finding something a bit closer, though, but East London doesn’t seem particularly …
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 production experience. Desktop application programming and web services experience are a must as is extensive …