HomeSoftware Heritage

origin_visit_get_latest: Order by visit id instead of date

This commit no longer exists in the repository. It may have been part of a branch which was deleted.

Description

origin_visit_get_latest: Order by visit id instead of date

This allows both the postgresql and cassandra backends to make efficient
queries by using an index (resp. clustering key) instead of scanning
all visits of the given origin then sorting by date.

This does not affect the results for the last majority of cases,
as ids are always in increasing chronological, unless an origin was
re-loaded from an old archive.

Details

Provenance
vlorentzAuthored on Mar 11 2022, 1:38 PM
vlorentzPushed on Mar 15 2022, 10:38 AM
Differential Revision
D7339: origin_visit_get_latest: Order by visit id instead of date
Build Status
Buildable 27440
Build 42940: test-and-buildJenkins console · Jenkins

Commit No Longer Exists

This commit no longer exists in the repository.