SharePoint 2007 performance issue caused by too many event receivers

If you have a huge number of webs in a SharePoint 2007 site collection with a large number of content types you might have come across some of the more esoteric performance limitations of SharePoint. Regardless of whether you've followed the best practice guidelines for number of sites, lists, list items etc you could fall foul of some rather dodgy SQL in the SharePoint content database.