upstream/mercurial-mirror Files · hgext/infinitepush/schema.sql

bookmarks: cache reverse mapping (issue5868)...

bookmarks: cache reverse mapping (issue5868) I chose a simpler implementation. If the initial cost of building reverse mapping is significant, we'll have to move it under @propertycache. The nodemap could be a dict of sets, but I think keeping a sorted list is better since each node is likely to have zero/one bookmark. Micro-benchmark with 1001 bookmarks and 1001 revisions: $ for n in `seq 0 1000`; do touch $n; hg book book$n; hg ci -qAm$n; done $ hg bookmarks --time > /dev/null (orig) time: real 0.040 secs (user 0.050+0.000 sys 0.000+0.000) (new) time: real 0.040 secs (user 0.040+0.000 sys 0.010+0.000) $ hg log -T '{bookmarks}\n' --time > /dev/null (orig) time: real 0.160 secs (user 0.160+0.000 sys 0.000+0.000) (new) time: real 0.090 secs (user 0.100+0.000 sys 0.000+0.000)

Pulkit Goyal - - Load All Authors

File last commit:

r37204:03ff17a4 default


                r38106:04ceb267

@26 default

Download file

             schema.sql
        
                    33 lines
            
             | 1.1 KiB
            
                | text/x-sql
            
             |
                TransactSqlLexer
            
             / hgext / infinitepush / schema.sql
          
                    History
                
                 |
                  Annotation
                 | Raw
                 |Copy content
                 |Copy permalink

      CREATE TABLE `bookmarkstonode` (

        `node` varbinary(64) NOT NULL,

        `bookmark` varbinary(512) NOT NULL,

        `reponame` varbinary(255) NOT NULL,

        PRIMARY KEY (`reponame`,`bookmark`)

      ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

      CREATE TABLE `bundles` (

        `bundle` varbinary(512) NOT NULL,

        `reponame` varbinary(255) NOT NULL,

        PRIMARY KEY (`bundle`,`reponame`)

      ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

      CREATE TABLE `nodestobundle` (

        `node` varbinary(64) NOT NULL,

        `bundle` varbinary(512) NOT NULL,

        `reponame` varbinary(255) NOT NULL,

        PRIMARY KEY (`node`,`reponame`)

      ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

      CREATE TABLE `nodesmetadata` (

        `node` varbinary(64) NOT NULL,

        `message` mediumblob NOT NULL,

        `p1` varbinary(64) NOT NULL,

        `p2` varbinary(64) DEFAULT NULL,

        `author` varbinary(255) NOT NULL,

        `committer` varbinary(255) DEFAULT NULL,

        `author_date` bigint(20) NOT NULL,

        `committer_date` bigint(20) DEFAULT NULL,

        `reponame` varbinary(255) NOT NULL,

        `optional_json_metadata` mediumblob,

        PRIMARY KEY (`reponame`,`node`)

      ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages

				CREATE TABLE `bookmarkstonode` (
				`node` varbinary(64) NOT NULL,
				`bookmark` varbinary(512) NOT NULL,
				`reponame` varbinary(255) NOT NULL,
				PRIMARY KEY (`reponame`,`bookmark`)
				) ENGINE=InnoDB DEFAULT CHARSET=utf8;

				CREATE TABLE `bundles` (
				`bundle` varbinary(512) NOT NULL,
				`reponame` varbinary(255) NOT NULL,
				PRIMARY KEY (`bundle`,`reponame`)
				) ENGINE=InnoDB DEFAULT CHARSET=utf8;

				CREATE TABLE `nodestobundle` (
				`node` varbinary(64) NOT NULL,
				`bundle` varbinary(512) NOT NULL,
				`reponame` varbinary(255) NOT NULL,
				PRIMARY KEY (`node`,`reponame`)
				) ENGINE=InnoDB DEFAULT CHARSET=utf8;

				CREATE TABLE `nodesmetadata` (
				`node` varbinary(64) NOT NULL,
				`message` mediumblob NOT NULL,
				`p1` varbinary(64) NOT NULL,
				`p2` varbinary(64) DEFAULT NULL,
				`author` varbinary(255) NOT NULL,
				`committer` varbinary(255) DEFAULT NULL,
				`author_date` bigint(20) NOT NULL,
				`committer_date` bigint(20) DEFAULT NULL,
				`reponame` varbinary(255) NOT NULL,
				`optional_json_metadata` mediumblob,
				PRIMARY KEY (`reponame`,`node`)
				) ENGINE=InnoDB DEFAULT CHARSET=utf8;