Fossil SCM

Index xmark(trid), otherwise writing the mark file can take hours.

joerg 2017-04-18 18:40 trunk
Commit 48d466ab73882c57bf50de59f05228ac7d7a2f41ccd6dbf00736918060849a67
1 file changed +1
--- src/export.c
+++ src/export.c
@@ -508,10 +508,11 @@
508508
if( g.argc!=2 && g.argc!=3 ){ usage("--git ?REPOSITORY?"); }
509509
510510
db_multi_exec("CREATE TEMPORARY TABLE oldblob(rid INTEGER PRIMARY KEY)");
511511
db_multi_exec("CREATE TEMPORARY TABLE oldcommit(rid INTEGER PRIMARY KEY)");
512512
db_multi_exec("CREATE TEMP TABLE xmark(tname TEXT UNIQUE, trid INT, tuuid TEXT)");
513
+ db_multi_exec("CREATE INDEX xmark_trid ON xmark(trid)");
513514
if( markfile_in!=0 ){
514515
Stmt qb,qc;
515516
FILE *f;
516517
int rid;
517518
518519
--- src/export.c
+++ src/export.c
@@ -508,10 +508,11 @@
508 if( g.argc!=2 && g.argc!=3 ){ usage("--git ?REPOSITORY?"); }
509
510 db_multi_exec("CREATE TEMPORARY TABLE oldblob(rid INTEGER PRIMARY KEY)");
511 db_multi_exec("CREATE TEMPORARY TABLE oldcommit(rid INTEGER PRIMARY KEY)");
512 db_multi_exec("CREATE TEMP TABLE xmark(tname TEXT UNIQUE, trid INT, tuuid TEXT)");
 
513 if( markfile_in!=0 ){
514 Stmt qb,qc;
515 FILE *f;
516 int rid;
517
518
--- src/export.c
+++ src/export.c
@@ -508,10 +508,11 @@
508 if( g.argc!=2 && g.argc!=3 ){ usage("--git ?REPOSITORY?"); }
509
510 db_multi_exec("CREATE TEMPORARY TABLE oldblob(rid INTEGER PRIMARY KEY)");
511 db_multi_exec("CREATE TEMPORARY TABLE oldcommit(rid INTEGER PRIMARY KEY)");
512 db_multi_exec("CREATE TEMP TABLE xmark(tname TEXT UNIQUE, trid INT, tuuid TEXT)");
513 db_multi_exec("CREATE INDEX xmark_trid ON xmark(trid)");
514 if( markfile_in!=0 ){
515 Stmt qb,qc;
516 FILE *f;
517 int rid;
518
519

Keyboard Shortcuts

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