X-Git-Url: http://git.bitcoin.ninja/index.cgi?a=blobdiff_plain;f=src%2Flookup.rs;h=0878860020a61d373d311f6cff150d101c389c48;hb=3b570d2a24b0d6f59921b72b86685b3d4ac3d229;hp=8def6f13750fa5cf556ac6c1a1106b6d4b70635a;hpb=189dc76d7f46b095752488b9353e076d6b8ac219;p=rapid-gossip-sync-server

diff --git a/src/lookup.rs b/src/lookup.rs
index 8def6f1..0878860 100644
--- a/src/lookup.rs
+++ b/src/lookup.rs
@@ -288,7 +288,7 @@ pub(super) async fn fetch_channel_updates<L: Deref>(delta_set: &mut DeltaSet, cl
 		SELECT id, direction, blob_signed, CAST(EXTRACT('epoch' from seen) AS BIGINT) AS seen
 		FROM channel_updates
 		WHERE seen >= TO_TIMESTAMP($1)
-		ORDER BY timestamp DESC
+		ORDER BY short_channel_id ASC, timestamp DESC
 		", [last_sync_timestamp_float]).await.unwrap();
 	let mut pinned_updates = Box::pin(intermediate_updates);
 	log_info!(logger, "Fetched intermediate rows in {:?}", start.elapsed());