Fossil SCM

In export --git, look up each check-in's primary parent by primary key instead of a subquery. Speeds up export by ~2.5x.

danshearer 2026-10-26 14:10 UTC trunk
Commit 8db155e97962356a426aa9283a397c8a990035e34120cc0a4e4a8892cb058fd9
1 file changed +1 -1
+1 -1
--- src/export.c
+++ src/export.c
@@ -646,11 +646,11 @@
646646
if( zComment==0 ) zComment = "null comment";
647647
printf("data %d\n%s\n", (int)strlen(zComment), zComment);
648648
db_prepare(&q3,
649649
"SELECT pid FROM plink"
650650
" WHERE cid=%d AND isprim"
651
- " AND pid IN (SELECT objid FROM event)",
651
+ " AND EXISTS(SELECT 1 FROM event WHERE objid=pid)",
652652
ckinId
653653
);
654654
if( db_step(&q3) == SQLITE_ROW ){
655655
int pid = db_column_int(&q3, 0);
656656
zMark = mark_name_from_rid(pid, &unused_mark);
657657
--- src/export.c
+++ src/export.c
@@ -646,11 +646,11 @@
646 if( zComment==0 ) zComment = "null comment";
647 printf("data %d\n%s\n", (int)strlen(zComment), zComment);
648 db_prepare(&q3,
649 "SELECT pid FROM plink"
650 " WHERE cid=%d AND isprim"
651 " AND pid IN (SELECT objid FROM event)",
652 ckinId
653 );
654 if( db_step(&q3) == SQLITE_ROW ){
655 int pid = db_column_int(&q3, 0);
656 zMark = mark_name_from_rid(pid, &unused_mark);
657
--- src/export.c
+++ src/export.c
@@ -646,11 +646,11 @@
646 if( zComment==0 ) zComment = "null comment";
647 printf("data %d\n%s\n", (int)strlen(zComment), zComment);
648 db_prepare(&q3,
649 "SELECT pid FROM plink"
650 " WHERE cid=%d AND isprim"
651 " AND EXISTS(SELECT 1 FROM event WHERE objid=pid)",
652 ckinId
653 );
654 if( db_step(&q3) == SQLITE_ROW ){
655 int pid = db_column_int(&q3, 0);
656 zMark = mark_name_from_rid(pid, &unused_mark);
657

Keyboard Shortcuts

Open search /
Next entry (timeline) j
Previous entry (timeline) k
Open focused entry Enter
Show this help ?
Toggle theme Top nav button