202: Clearing Out Old Records

[Cashito]

Anyone know the best way to clear out data from say 3 months ago back from prosper202? Its getting sllllooowww.

Yes I posted on that forum. Yes it takes forever, IF ever to get a reply.

Any help appreciated.

 

[Onedollaridea]

nuke the old data using phpadmin

 

[invisible777]

cpanel -> phpmyadmin -> truncate the tables that have huge amounts od data stored in them.

 

[testonej]

have you tried just partitioning out the data tables? I wrote a post on it a while back and I think it is hotlinked from P202 install instructions now. Make sure your large click tables have partitions by date range on them (dont by default except for latest prosper release)