Geekery
At home for once this evening, and even though I’ve spent part of the evening asleep, and the rest setting up a selection of new phones about the house (we can now do SMS on landlines. Madness), I’ve done a little bit of work on this here website. Done a little work on the archive, so you can get to old entries, but still needs a bit of work.
Added about 20 million calls to stripslashes( ) to clear out all of the slashes in the comments.
Work today has been interesting. My pet product has been running slow for the last week, and I’ve been tearing my hair out trying to work out why (not a good idea when you’re already balding). Turns out for some reason I’d put two tables in an SQL UPDATE command, so it was creating a temporary table of 6 million records every time it did an update, rather than just a table of 30000. Oops. I’m at a loss to why I put the second table in there. Must have been tired. Roadsigns should say “Tiredness when programming can kill, take a break every two hours”.
This has been a public service announcement…
SQL queries are always best looked at later on. I had one on my photos site that was taking 1 second to execute. A quick rewrite and it now takes less than .05s.
Hosts like it when you sort stuff like that out
Well, this one was taking 90 seconds and locking up the CPU for that time too!
Yeah, that’s never good.
Have you cleaned out some of your archive? Nothing before last Christmas I see. Also, days with more than one post don’t appear to exist…
Hmm, haven’t checked for before last Christmas. Those should be there… I know about the more than one post thing – some of the code to deal with it is in, but I haven’t written the code to display a day with 2 entries yet, just single entries. Coming soon!