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.
Commit
8db155e97962356a426aa9283a397c8a990035e34120cc0a4e4a8892cb058fd9
Parent
e66a8c79ad286ed…
1 file changed
+1
-1
+1
-1
| --- src/export.c | ||
| +++ src/export.c | ||
| @@ -646,11 +646,11 @@ | ||
| 646 | 646 | if( zComment==0 ) zComment = "null comment"; |
| 647 | 647 | printf("data %d\n%s\n", (int)strlen(zComment), zComment); |
| 648 | 648 | db_prepare(&q3, |
| 649 | 649 | "SELECT pid FROM plink" |
| 650 | 650 | " WHERE cid=%d AND isprim" |
| 651 | - " AND pid IN (SELECT objid FROM event)", | |
| 651 | + " AND EXISTS(SELECT 1 FROM event WHERE objid=pid)", | |
| 652 | 652 | ckinId |
| 653 | 653 | ); |
| 654 | 654 | if( db_step(&q3) == SQLITE_ROW ){ |
| 655 | 655 | int pid = db_column_int(&q3, 0); |
| 656 | 656 | zMark = mark_name_from_rid(pid, &unused_mark); |
| 657 | 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 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 |