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 table to clear for an hour. The solution is to use a combination of SHOW …
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 run it all in a single database call. Until stored procedures (in MySQL 5) are …
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 that MySQL sometimes decides not to use an index even when a handy one seems …
It’s hard not to know about Yo Sushi, the ‘famous’ conveyor belt sushi restaurant, but what’s not so well known is that the idea is almost a direct import from Japan where such restaurants are more common. Gili Gulu is another along the same vein in central London just off the main stretch between Leicester …
Another one of those ‘I wish PHP 5 did this…’ moments has occurred to me with class constants. The addition of constants is good but the problem is when it comes to subclassing. The code on the PHP 5 site: class Foo { const constant = “constant”; } echo “Foo::constant = ” . Foo::constant . …
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 …