Jump to:

3430 Posts in 1057 Topics by 734 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: 371 Views
  • RobboDev
    Avatar
    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.

    Cheers
    Rob Clarkson

  • frankmullenger
    Avatar
    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...

    371 Views
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.