optimized revisions lookups