Jump to:

23459 Posts in 18906 Topics by 2877 members

General Questions

SilverStripe Forums » General Questions » # of page revisions vs performance?

General questions about getting started with SilverStripe that don't fit in any of the categories above.

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

Page: 1
Go to End
Author Topic: 193 Views
  • forumq42
    Avatar
    Community Member
    12 Posts

    # of page revisions vs performance? Link to this post

    This question came up the other day:

    What sort of performance hit is caused by having pages with many revisions (for that matter, what would be considered a large # of revisions for SilverStripe pages)?

    Some of our pages have perhaps 150 revisions on sites with 500-2000 pages. Some pages are short, some are manuals/documentation that can be fairly long with many sections.

    We're trying to determine whether to start purging the oldest pages and what a useful threshold (time / # of revisions) is useful to keep around if there is a serious hit on performance.

    Anyone investigate something like this?

  • Willr
    Avatar
    Forum Moderator
    5497 Posts

    Re: # of page revisions vs performance? Link to this post

    For the general performance, lots of versions shouldn't cause any performance issues as I don't think anything will query your versions table. You can check the MYSQL queries that get executed on the page and check if any of them query _versions.

    193 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.