Some related posts from Technorati and Google.

[AIS, SEO, PHP, Daily Stuff and more : Blogs by Sarah] Spam Problems: SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND YEAR(post_date)='2006' AND MONTH(post_date)='3' AND DAYOFMONTH(post_date)='2' AND post_name = 'spam-problems' AND post_date_gmt

 [DenisDeKat’s Symposium] On Referral Spam: On Referral Spam Filed under: Technology Internet Blogging ”” denisdekat @ 10:03 am We hatesss itsss”¦. They wantsss the preciouss visitssss and linkssss”¦. Today I lost it and I set up this rewrite rule I should have set up eons ago”¦. RewriteEngine on RewriteCond %{HTTP_REFERER} (4t\.com) RewriteCond %{HTTP_REFERER} (8k\.com)

 [Blogesque] Worst Contact: Because in just over a week's time, spammers and their spambots have sucked up the same amount of bandwidth I typically use in an entire month. It hasn't yet reached the level of a DoS attack, and I have no intention of letting it get that far.

[Because I Say So] .htaccess file test: htaccess files are processed on a line-by-line basis, I would imagine there is a fair hit on the server having a .htaccess file of this size on it (depending on how much traffic your site is receiving, of course - more traffic means heavier hit).

 [Unknowngenius.com] Dr Dave » Referrer Karma: anti-comment-spam plugin Spam Karma to block spambots before they even reach your comment page (note that you do not need to be running either SK or WP in order to use RK: this feature is entirely optional).

 [Underscorebleach.net] Proposal on referrer spam: The reason I suggest that the spam analysis not be done at HTTP request time is that if external blacklists (whether DNSBLs, XML-RPC-based, or otherwise) are to be queried, this could slow down the response of the Web server significantly. It would be a problem particularly if such an anti-referrer spam system were widely adopted and the blacklist's server was getting hammered (or was the target of a DoS).

Reflected tags on Technorati: Blog, Referral Spam, Targeting Spam