Support Forum
Support Forum
Offline
I've just installed the prune database plugin so I can reduce the size of my very large database but I think there's a serious oversight with the plugin, there should be an option to prune topics based on last reply date rather than creation date. Some topics, while they were created a long time ago are still active, and while you have the option to go through and select certain topics from a filtered list, there's no easy way to see the date of the last post to see which topics are still (or recently) active. Any chance this can be altered soon? It seems (to someone who doesn't really know) it shouldn't be too hard to create an extra option to select by last reply date instead of topic creation date... ?
Offline
That's a really very good point.
I will open a ticket right away to see about changing it
 |
YELLOW
SWORDFISH
|
Offline
Aside from that request... it seems like nothing happens when I prune anyway... any reasons people know of it wouldn't actually do anything even after it pops up a message saying it's been pruned?
Offline
Offhand no. It appears to be working on my test sites just fine as I literally just tried it.
You do need to be judicious and not throw huge numbers at it in one go which is something we do have logged to address one day. To be honest this might be the first time it has ever been mentioned in a support question! Which means it tens to fall off the edge as far as priority goes.
But try it in small numbers - I just pruned about 180 topics with no problem - and, as I say, it works fine this end. Could it be that it did some of the work but not all that you asked it to?
|
YELLOW
SWORDFISH
|
Offline
I was just coming back to report it works on a smaller number of topics. I guess I should just wait and hope and update is out soon so I can be more selective about what I want to delete anyway.
I've been running SP since 2008 so there's a lot of old posts to prune, but my database is about 490mb now so it's time! I made a copy of the forums on another server so I can keep an archive for our users who hate the idea of losing any old posts at all.
Offline
Yes I had already stated on the ticket that we need to also find a way to force the removals to be in small batches in some way...
|
YELLOW
SWORDFISH
|
Offline
the number that can be removed is going to be server dependent... before it exhausts resources... I works on my big server, but we do need to cater to the lower common denominator...
Visit Cruise Talk Central and Mr Papa's World
Offline
Are you able to provide any idea of timeline for this alteration? Are we talking days, weeks or months? I need to make a decision about whether or not I should fumble my way through as is or try and wait for an update
Offline
I will attempt to look some time today at the query to see if the last post date can be used instead of the topic start date. That bis the easy bit and I might even be able to give you a code change.
Batching and requesting smaller numbers for the server to work on at any one time is a far, far bigger task I am afraid.
|
YELLOW
SWORDFISH
|
All RSS