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

fix: reduce number of tool executions...

fix: reduce number of tool executions By grouping together (path, ctx) pairs according to the inputs they would provide to fixer tools, we can deduplicate executions of fixer tools to significantly reduce the amount of time spent running slow tools. This change does not handle clean files in the working copy, which could still be deduplicated against the files in the checked out commit. It's a little harder to do that because the filerev is not available in the workingfilectx (and it doesn't exist for added files). Anecdotally, this change makes some real uses cases at Google 10x faster. I think we were originally hesitant to do this because the benefits weren't obvious, and implementing it efficiently is kind of tricky. If we simply memoized the formatter execution function, we would be keeping tons of file content in memory. Also included is a regression test for a corner case that I broke with my first attempt at optimizing this code. Differential Revision: https://phab.mercurial-scm.org/D11280

Pulkit Goyal - - Load All Authors

File last commit:

r37204:03ff17a4 default


                r48992:f12a19d0

default

Download file

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

        Pulkit Goyal
    
infinitepush: move the extension to core from fb-hgext...

              r37204
            
      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

Pulkit Goyal infinitepush: move the extension to core from fb-hgext...	r37204	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;