Anyhow, tying that back into Aaron's question - no, its not cheaper than what we do today (because the IS NOT NULL optimisation can be applied today) - the logic to determine 'highest sequence number with a date older than $proposal state' itself involves loading -all- revisions in the mainline.
Anyhow, tying that back into Aaron's question - no, its not cheaper than what we do today (because the IS NOT NULL optimisation can be applied today) - the logic to determine 'highest sequence number with a date older than $proposal state' itself involves loading -all- revisions in the mainline.