Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

We've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

General Questions /

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

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

# of page revisions vs performance?


Go to End


2 Posts   1090 Views

Avatar
forumq42

Community Member, 18 Posts

24 September 2013 at 9:54am

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?

Avatar
Willr

Forum Moderator, 5523 Posts

28 September 2013 at 5:27pm

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.