geocacheuk.com in United Kingdom and Ireland Posted July 16, 2009 I don't think I ever had the pleasure of visiting geocacheuk.com, but I do have some experience with PHP/MySQL....what needs doing?/ The first task would be to rewrite the search code. In order to improve the response time when flicking through the results of a search, the entire set of UK caches, customised for that particular user, is cached in MySQL, in a common table. That didn't exactly scale well! Quick fixes such as limiting the number of results returned would be possible, but unsatisfying (one of the unique features of G:UK was that anyone could download the entire set of UK caches, customised for them, in one go. People who contributed PQs could get this in GPX format too). The other main performance task was that the insertion of PQs slowed down the site for web users. This meant a lot of my time went into maintaining "rotas" of which users contributed which PQs, so as to make this as efficient as possible. It would be nice to have a program which first read in several hundred XML files in one go, consolidating them into a data structure. This could then be filtered against a read-only cursor against the DB, then finally, any required updates could be done in a single, efficient blast. The work required to get the site working isn't rocket science. It just needs an experienced coder with some enthusiasm. I carried on maintaining the site for a long time after I stopped geocaching myself, but events in the forums made me wonder why I was busting a gut to support Groundspeak's website (with their permission, but clearly against their preferences), when their attitude towards UK geocaching was so objectionable.