Jump to:

3448 Posts in 1062 Topics by 738 members

Data Model Questions

SilverStripe Forums » Data Model Questions » Page versions filling up the DB

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Page: 1
Go to End
Author Topic: 384 Views
  • RobboDev
    Community Member
    20 Posts

    Page versions filling up the DB Link to this post

    Hi guys,

    Just taken a look at the DB of a 2.4 SS website I've had for a while. I can see that "page versions" is taking up 500mb of the DB. Are the versions designed to hold every version of a page ever? or am I doing it wrong?

    Whats the best way to deal with this? Thanks for any help.

    Rob Clarkson

  • frankmullenger
    Forum Moderator
    51 Posts

    Re: Page versions filling up the DB Link to this post

    I think it is designed to store every version of a page ever so you're not doing anything wrong. I imagine you could trim a lot of the rows from that table without effecting the user experience really, unless your users want to go back a few years in their page history for some reason.

    Might be a good case for using a SilverStripe task to clean up the old site tree versions rather than doing it directly on the DB...

Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.