Pruning Old Posts from Wordpress

I run quite a few wordpress blogs, all running statpress for the stats.

However some are getting quite large and slow. I was wondering has anybody ever come up with a way of pruning old posts that haven't been viewing for xx days. In theory the data should be in statpress, and it should even tell you whether it was a spider or a real human that viewed the page.

Even just coming up with an SQL query to find unviewed pages would help me.

Note that adblockers might block our captcha, and other functionality on BHW so if you don't see the captcha or see reduced functionality please disable adblockers to ensure full functionality, note we only allow relevant management verified ads on BHW.