CVSTrac Legacy Code

Check-in [c6b04561ea]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:(#777) an index on filechng(vers) speeds the update quite a bit for larger projects.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:c6b04561ea7d96414db61c67a5cef61970b8ff9a
User & Date: cpb 2009-01-17 16:31:03
Context
2009-02-19
02:33
(#781) don't run the external diff filter if the output is supposed to be _raw_ check-in: 488fc0db1e user: cpb tags: trunk
2009-01-17
16:31
(#777) an index on filechng(vers) speeds the update quite a bit for larger projects. check-in: c6b04561ea user: cpb tags: trunk
2008-12-28
15:03
(#774) make external tools work in reports check-in: 976179c75a user: cpb tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to git.c.

608
609
610
611
612
613
614

615
616
617
618
619
620
621
  db_execute( "CREATE TEMP TABLE seenrefs(name);");

  if( sqlite3_libversion_number() >= 3003008 ){
    /* Ref checks should be really quick since they happen on every update.
    ** This index improves performance by at least an order of magnitude.
    */
    db_execute("CREATE INDEX IF NOT EXISTS git_idx1 ON chng(branch,directory)");

  }

  /* Read the refs and ingest the commit tree */
  nNewRevs = git_read_refs(zRoot);

  if( nNewRevs==0 ) {
    /* Might be a little inefficient to call this each time, but since







>







608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
  db_execute( "CREATE TEMP TABLE seenrefs(name);");

  if( sqlite3_libversion_number() >= 3003008 ){
    /* Ref checks should be really quick since they happen on every update.
    ** This index improves performance by at least an order of magnitude.
    */
    db_execute("CREATE INDEX IF NOT EXISTS git_idx1 ON chng(branch,directory)");
    db_execute("CREATE INDEX IF NOT EXISTS git_idx2 ON filechng(vers)");
  }

  /* Read the refs and ingest the commit tree */
  nNewRevs = git_read_refs(zRoot);

  if( nNewRevs==0 ) {
    /* Might be a little inefficient to call this each time, but since