My blog. It may be interesting, but the chances of that are pretty slim...
Visit Marky Moo's Blog
Sponsor: MP3 music download
Thursday, October 21, 2004
Fantasy Football Passwords
Looking for the Daily Telegraph Fantasy Football Passwords?
Don't forget, if you are looking for British Blogs, then there is only one place to go ;-)
Tuesday, August 17, 2004
I've moved to WordPress
OK, I gave in with the wait for a PostgreSQL WordPress port, and am testing the MySQL-based version.
My blog can now be found at: http://www.sweeting.org/mark/blog/
There will (probably) be no more activity on this site. Please let me know any comments you have on this new blog :-)
Monday, August 16, 2004
The ramblings of someone taking psychedelic chemicals*
Had a good time in Cambridge. I was staying with some friends who have just bought a house in a pleasant little village just outside of the town. Within two hours of me arriving we all found ourselves locked out of the house, which could have been slightly awkward. However, like true piss-heads, we managed to make the most of it. We’d already had some G&Ts, so we went to the pub and had a swift half of local ale, while making use of the amenities. After a quick stop in the local shop to stock up on wine (with screw tops), it was off to the train station for us as we set out in pursuit of the spare front door key.
The journey to King’s Lynn was swift, and we managed to ration the wine well. Luckily P’s parents live half an hour’s drive from here, and her father kindly met us there with the spare front door key. 40 minutes later we were back in Cambridge (with empty bottles of wine), and we managed to make it to the engagement party as intended (albeit slightly later).
Had to get up at 6:30 this morning to finish some work off for a client (and have it ready for him at 9.00 AM). Urgh, I think I may go back to bed now!
*By the way, I don't really take psychedelic chemicals.
Saturday, August 14, 2004
The power of beer
It's amazing what you can do after a few drinks.
I've just re-written the directory summaries (popular locations, popular categories, popular interests) on BritBlog so that they all use cached data (held in arrays in files) instead of hitting the database with a query each time. I've not done any tests, but it must be loads quicker. The queries used to have two
JOINs (i.e. three tables) and
WHERE clauses, so they weren't exactly light-weight. The database is on a physically separate server too, so that won't help things either. The cache arrays are updated every four hours via a cron job, so they should never be too out of sync with the real values. All I have to do now is apply a few sorts to them to get the data in the different orders that I need.
I went through and replaced several other database queries in this manner too :-)
I've also added an index of all the interests people have. Again, this is built from a cached snap-shot of the database, so it's pretty swift.
And what did I learn with this exercise? Well, I learned how to use the usort function for sorting multi-dimensional arrays. That's pretty nifty!
Well, this post is boring the tits off me. I'm new to this blogging thing, and when I started one of my planned uses for this blog was to talk about the work I do on BritBlog. So there you have it: work I did on BritBlog.
Got to go to Cambridge tomorrow night (um, actually tonight now). Yet another friend has got engaged (- the world has gone mad!) Still, it should be a good crack. It's always good to meet up with my friends from up there :-)