Old Page Versions - Difficult to Remove - What could it indicate?

Permalink
Looking for any expert advice regarding Old Page Versions.

One of the first sites I created using C5 (updated to 5.5.1) has been plagued by Old Page Versions, should have about 1,000 total, but have 9,000. The reason for the high amount is that I did not know at the time that all versions of a page carry over to a copied page, thus if a page has 200 versions, the copy will have 200 versions.

It seems endless in trying to manually remove the old versions. The new 5.5.1 automated tool will remove about 20 at a time in 10 minutes and then stops, with the throbber continuing to churn.

The reason I want to remove the old version is that I believe they are slowing down the site. However, I am now thinking that the problem of removing old versions is actually related to why the site is slow.

I have other sites on the same Blue Host Server and do not have a problem with speed or removal of old page versions.

Does anyone have any thoughts on what could be the reason as to the difficulty in removing page versions or what could be a fix?

At the end of a rope on this one, much time wrestling with the overall speed issue, probably could have rebuilt the site many times over, which will be my next step if I can't find a solution.

MrGrowBizz
 
prestressed replied on at Permalink Reply
prestressed
I can't remove old page versions either, at least only 10 or so at a time. I'm on 5.5.2.1 now. The Automated Job which is supposed to remove old versions just doesn't run (in Firefox or IE) - it always says 0 versions deleted from 0 Pages, but there were probably at least 2000 old versions (due to the above-mentioned issue with copying pages...)

I am trying to remove them manually but it is taking forever, so I feel your pain! Did you have any success at finding a faster solution?
MrGrowBizz replied on at Permalink Reply
MrGrowBizz
Have not had any luck, and have not found a solution.
Mainio replied on at Permalink Reply
Mainio
The reason for this is probably because it really loads everything for those page versions (including version attributes and version styles) as it goes through them.

This would probably be quite much faster with plain SQL delete queries, we can build that for you if interested.

Best,
Antti / Mainio
MrGrowBizz replied on at Permalink Reply
MrGrowBizz
Mainio, It's hard to believe someone has not found a solution to this problem. Appreciate your willingness to assist. Obviously at the time of building the referenced site I was not the sharpest tool in the shed in using C5. Unfortunately it is key site of mine and need to find a solution to removing the old versions, versus rebuilding the site.
hostco replied on at Permalink Reply
hostco
By default PHP script execution time is set for 30 seconds in your php.ini file.

The job stops running because it needs more then 30 seconds to finish.

Try adding this line to your php.ini file and running the job again.

max_execution_time = 60


If 60 seconds is not enough try increasing it.