Re: [Subtext-devs] SQL Script for clearing common referrers

[Si P. <si_...@ho...>]

 
Only one I can recall was from Travis:


Date: Tue, 2 Dec 2008 07:57:30 -0800From: ti...@pa...To: sub...@li...Subject: [Subtext-devs] Database Maintenance Page
Hey, gang:
 
I was doing some DB maintenance last night, cleaning up my referrals based on the logic Phil posted a while back here:
 
http://haacked.com/archive/2006/02/06/databasemaintenanceofyourblog.aspx
 
Referrals take up a lot more space than I realized and I started bumping up against my database size limit a while ago - almost a third of the space was eaten by referrals and error log. I have to watch that as my traffic increases or I have to start paying for more DB space.
 
Anyway, I created a simple DB maintenance page that lets you clear out most search engine referrals and a lot of referral spam without having to pop into SQL Management Studio. (When you're not on your own box, getting admin privileges enabled so you can remotely connect to SQL with Management Studio is... well, sometimes difficult.)
 
Since I'm stuck on 1.9.5b due to the medium trust issues with the latest (I borked my blog for a couple of days last time I tried upgrading - again, no TS access, no admin access to SQL or the filesystem, and no failed-install-rollback, so I'm at the mercy of the operators on duty to restore me from backup), the page is specifically for 1.9.5b and, while it probably works in 2.x, I've not tried it and don't have that environment up so I can. I didn't feel like it'd be good as a patch and wrote it more as a standalone page you drop in the Admin folder - all the code is in the ASPX so you don't need anything but the page.
 
I was considering blogging it, but is there a better place to put it than "just blogging it?" Or is that the best bet considering the state it's in?
 
-T
--Travis Illighttp://www.paraesthesia.com
 



Date: Sun, 1 Feb 2009 16:25:05 -0500From: ste...@gm...To: sub...@li...Subject: [Subtext-devs] SQL Script for clearing common referrersAll,A while ago (possibly a few years ago even), someone posted a SQL script that they used to clear "common referrers" out of their referrers log for their blog. Basically, I'd like to remove common search engine referrers (like Google, MSN, Yahoo, etc...) so I can see actual organic referrers. Anyone still have such a script?-steve//----  90% of being smart is knowing what you're dumb at  ----//http://stevenharman.net/
_________________________________________________________________
Love Hotmail?  Check out the new services from Windows Live! 
http://clk.atdmt.com/UKM/go/132630768/direct/01/