From 7073e5cc0860ccbe739f97eaa116d10b639a3005 Mon Sep 17 00:00:00 2001
From: Arun Isaac
Date: Wed, 26 Aug 2026 14:39:32 +0100
Subject: Re-order extracted path_segment table for optimal access.

---
 domagi/domagi.py | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

diff --git a/domagi/domagi.py b/domagi/domagi.py
index e2bf457..20f5837 100644
--- a/domagi/domagi.py
+++ b/domagi/domagi.py
@@ -262,7 +262,9 @@ def extract(con, outfile, segment_name, path_range, steps, threads, progress):
     INSERT INTO subset_db.path_segment
     SELECT path_id, segment_id, segment_orientation, start, "end"
     FROM selected_segment
-    INNER JOIN path_segment ON path_segment.segment_id=selected_segment.id;
+    INNER JOIN path_segment ON path_segment.segment_id=selected_segment.id
+    -- Re-order similar to post-import.sql for optimal access.
+    ORDER BY path_id, start, "end";
     
     INSERT INTO subset_db.path
     SELECT id, ANY_VALUE(name)
-- 
cgit 1.4.1