Personal

Use DB indexes…

<![CDATA[Indexes or indices? If this was anything but an article on databases I'd use indices.

Anyway, XHTML Friends was taking about 3 minutes to load a page. I added three indexes to two tables and now it takes a few seconds.

I have never seen such a speed increase come from adding indexes to a database.

So let this be a lesson to me…]]>

Personal

More XFN

<![CDATA[Well if you have a URL you want crawled go to http://brownab1.miniserver.com/xfn/crawl.php.

If you want to have a look at the pages already there in a nice graphical network display, go to http://brownab1.miniserver.com/xfn/image.php.

This displays 26 random sites and the links between them. If you click on a site it “holds” it so subsequent requests always contain this site (this way you can slowly buildup an image of sites that actually link to each other).]]>

Galaxia

Pretty XFN

<![CDATA[XFN stands for XML Friends Network. You basically define human relationships between webpage authors by adding an extra atribute to links.

Well I decded to write a nice XFN crawler/search engine thingy. The crawler part works. I also decided to do a nice graphical representation of the links between sites.

Red is "crush", blue is "met" and green is "friend" (just three properties I picked at random).

XFN Network]]>

Google

Google will take over the world…

<![CDATA[Google are going from strength to strength. Their take over of America is well documented on my old blog, but they the movetowards global domination today, releasing UK versions of Google Local and Google Maps. The rest of the world must surely follow.

For those of you who do not believe me and haven't read my previous posts on the matter, check the following:

  • maps.google.com
  • maps.google.co.uk
  • local.google.com
  • local.google.co.uk
  • video.google.com
  • catalogs.google.com
  • froogle.google.com
  • froogle.google.co.uk
  • froogle.google.de

Google Catalogs is possible the most impresive. Although the fact that Google Maps in America now has (completely free) aerial photo data is cool. One funny thing is to go look at the Whitehouse with the mysteriously edited image erasing it completely (not Google’s doing; in their blog they were just as surprised to find it).

maps, Google, Froogle]]>