For informational/brochureware sites that aren't being updated all the time, scan these tables looking at the timestamp.

node_revisions
history
files
comments

If there is one in there that is greater then the stored value then go ahead and expire content that needs to be expired; or even do a complete flush of the site. This would be done on cron. If nothing has changed, keep the site as is; no need to expire content.

CommentFileSizeAuthor
#2 boost-546732.patch4.5 KBmikeytown2

Comments

mikeytown2’s picture

node - created, changed
node_comment_statistics - last_comment_timestamp

any other tables?

mikeytown2’s picture

Status: Active » Needs review
StatusFileSize
new4.5 KB
mikeytown2’s picture

Status: Needs review » Fixed

committed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.