{"action":"created","comment":{"url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/pulls/comments/212833866","pull_request_review_id":149545748,"id":212833866,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDIxMjgzMzg2Ng==","diff_hunk":"@@ -64,6 +64,8 @@ DbCommand CreateReadCommand(DbConnection connection)\n             id.Value = _random.Next(1, 10001);\n             cmd.Parameters.Add(id);\n \n+            (cmd as MySql.Data.MySqlClient.MySqlCommand)?.Prepare();","path":"frameworks/CSharp/aspnetcore/Benchmarks/Data/RawDb.cs","position":4,"original_position":4,"commit_id":"5b3cef95595d7690f9569173df6b7b9693e1f7a7","original_commit_id":"5b3cef95595d7690f9569173df6b7b9693e1f7a7","user":{"login":"roji","id":1862641,"node_id":"MDQ6VXNlcjE4NjI2NDE=","avatar_url":"https://avatars0.githubusercontent.com/u/1862641?v=4","gravatar_id":"","url":"https://api.github.com/users/roji","html_url":"https://github.com/roji","followers_url":"https://api.github.com/users/roji/followers","following_url":"https://api.github.com/users/roji/following{/other_user}","gists_url":"https://api.github.com/users/roji/gists{/gist_id}","starred_url":"https://api.github.com/users/roji/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/roji/subscriptions","organizations_url":"https://api.github.com/users/roji/orgs","repos_url":"https://api.github.com/users/roji/repos","events_url":"https://api.github.com/users/roji/events{/privacy}","received_events_url":"https://api.github.com/users/roji/received_events","type":"User","site_admin":false},"body":"In principle an explicit `Prepare()` should be best for Npgsql. But IIRC there was some unexplained weirdness at some point where using auto-prepare was actually faster than explicit `Prepare()`. I didn't have any time to look into it (and don't have any right now either...), but maybe @sebastienros can re-confirm this...","created_at":"2018-08-26T17:50:14Z","updated_at":"2018-08-26T17:50:15Z","html_url":"https://github.com/TechEmpower/FrameworkBenchmarks/pull/4015#discussion_r212833866","pull_request_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/pulls/4015","author_association":"NONE","_links":{"self":{"href":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/pulls/comments/212833866"},"html":{"href":"https://github.com/TechEmpower/FrameworkBenchmarks/pull/4015#discussion_r212833866"},"pull_request":{"href":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/pulls/4015"}},"in_reply_to_id":212807429},"pull_request":{"url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/pulls/4015","id":210883803,"node_id":"MDExOlB1bGxSZXF1ZXN0MjEwODgzODAz","html_url":"https://github.com/TechEmpower/FrameworkBenchmarks/pull/4015","diff_url":"https://github.com/TechEmpower/FrameworkBenchmarks/pull/4015.diff","patch_url":"https://github.com/TechEmpower/FrameworkBenchmarks/pull/4015.patch","issue_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/issues/4015","number":4015,"state":"open","locked":false,"title":"Improve aspcore + MySQL benchmarks","user":{"login":"bgrainger","id":188129,"node_id":"MDQ6VXNlcjE4ODEyOQ==","avatar_url":"https://avatars2.githubusercontent.com/u/188129?v=4","gravatar_id":"","url":"https://api.github.com/users/bgrainger","html_url":"https://github.com/bgrainger","followers_url":"https://api.github.com/users/bgrainger/followers","following_url":"https://api.github.com/users/bgrainger/following{/other_user}","gists_url":"https://api.github.com/users/bgrainger/gists{/gist_id}","starred_url":"https://api.github.com/users/bgrainger/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bgrainger/subscriptions","organizations_url":"https://api.github.com/users/bgrainger/orgs","repos_url":"https://api.github.com/users/bgrainger/repos","events_url":"https://api.github.com/users/bgrainger/events{/privacy}","received_events_url":"https://api.github.com/users/bgrainger/received_events","type":"User","site_admin":false},"body":"","created_at":"2018-08-25T03:51:21Z","updated_at":"2018-08-26T17:50:15Z","closed_at":null,"merged_at":null,"merge_commit_sha":"ef7e4ebdb7700c183f200736786d4ee6993db3fc","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/pulls/4015/commits","review_comments_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/pulls/4015/comments","review_comment_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/pulls/comments{/number}","comments_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/issues/4015/comments","statuses_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/statuses/5b3cef95595d7690f9569173df6b7b9693e1f7a7","head":{"label":"bgrainger:mysqlconnector","ref":"mysqlconnector","sha":"5b3cef95595d7690f9569173df6b7b9693e1f7a7","user":{"login":"bgrainger","id":188129,"node_id":"MDQ6VXNlcjE4ODEyOQ==","avatar_url":"https://avatars2.githubusercontent.com/u/188129?v=4","gravatar_id":"","url":"https://api.github.com/users/bgrainger","html_url":"https://github.com/bgrainger","followers_url":"https://api.github.com/users/bgrainger/followers","following_url":"https://api.github.com/users/bgrainger/following{/other_user}","gists_url":"https://api.github.com/users/bgrainger/gists{/gist_id}","starred_url":"https://api.github.com/users/bgrainger/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bgrainger/subscriptions","organizations_url":"https://api.github.com/users/bgrainger/orgs","repos_url":"https://api.github.com/users/bgrainger/repos","events_url":"https://api.github.com/users/bgrainger/events{/privacy}","received_events_url":"https://api.github.com/users/bgrainger/received_events","type":"User","site_admin":false},"repo":{"id":133580919,"node_id":"MDEwOlJlcG9zaXRvcnkxMzM1ODA5MTk=","name":"FrameworkBenchmarks","full_name":"bgrainger/FrameworkBenchmarks","owner":{"login":"bgrainger","id":188129,"node_id":"MDQ6VXNlcjE4ODEyOQ==","avatar_url":"https://avatars2.githubusercontent.com/u/188129?v=4","gravatar_id":"","url":"https://api.github.com/users/bgrainger","html_url":"https://github.com/bgrainger","followers_url":"https://api.github.com/users/bgrainger/followers","following_url":"https://api.github.com/users/bgrainger/following{/other_user}","gists_url":"https://api.github.com/users/bgrainger/gists{/gist_id}","starred_url":"https://api.github.com/users/bgrainger/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bgrainger/subscriptions","organizations_url":"https://api.github.com/users/bgrainger/orgs","repos_url":"https://api.github.com/users/bgrainger/repos","events_url":"https://api.github.com/users/bgrainger/events{/privacy}","received_events_url":"https://api.github.com/users/bgrainger/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/bgrainger/FrameworkBenchmarks","description":"Source for the TechEmpower Framework Benchmarks project","fork":true,"url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks","forks_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/forks","keys_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/keys{/key_id}","collaborators_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/teams","hooks_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/hooks","issue_events_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/issues/events{/number}","events_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/events","assignees_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/assignees{/user}","branches_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/branches{/branch}","tags_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/tags","blobs_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/git/refs{/sha}","trees_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/git/trees{/sha}","statuses_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/statuses/{sha}","languages_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/languages","stargazers_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/stargazers","contributors_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/contributors","subscribers_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/subscribers","subscription_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/subscription","commits_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/commits{/sha}","git_commits_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/git/commits{/sha}","comments_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/comments{/number}","issue_comment_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/issues/comments{/number}","contents_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/contents/{+path}","compare_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/compare/{base}...{head}","merges_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/merges","archive_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/downloads","issues_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/issues{/number}","pulls_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/pulls{/number}","milestones_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/milestones{/number}","notifications_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/labels{/name}","releases_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/releases{/id}","deployments_url":"https://api.github.com/repos/bgrainger/FrameworkBenchmarks/deployments","created_at":"2018-05-15T22:42:44Z","updated_at":"2018-06-10T03:56:48Z","pushed_at":"2018-08-25T03:49:43Z","git_url":"git://github.com/bgrainger/FrameworkBenchmarks.git","ssh_url":"git@github.com:bgrainger/FrameworkBenchmarks.git","clone_url":"https://github.com/bgrainger/FrameworkBenchmarks.git","svn_url":"https://github.com/bgrainger/FrameworkBenchmarks","homepage":"https://www.techempower.com/benchmarks/","size":272796,"stargazers_count":0,"watchers_count":0,"language":"PHP","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":1,"mirror_url":null,"archived":false,"open_issues_count":0,"license":{"key":"bsd-3-clause","name":"BSD 3-Clause \"New\" or \"Revised\" License","spdx_id":"BSD-3-Clause","url":"https://api.github.com/licenses/bsd-3-clause","node_id":"MDc6TGljZW5zZTU="},"forks":1,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"TechEmpower:master","ref":"master","sha":"4b0ad301bcb1faa6e7890d6ec61c41b4cacc44b6","user":{"login":"TechEmpower","id":3910062,"node_id":"MDEyOk9yZ2FuaXphdGlvbjM5MTAwNjI=","avatar_url":"https://avatars2.githubusercontent.com/u/3910062?v=4","gravatar_id":"","url":"https://api.github.com/users/TechEmpower","html_url":"https://github.com/TechEmpower","followers_url":"https://api.github.com/users/TechEmpower/followers","following_url":"https://api.github.com/users/TechEmpower/following{/other_user}","gists_url":"https://api.github.com/users/TechEmpower/gists{/gist_id}","starred_url":"https://api.github.com/users/TechEmpower/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/TechEmpower/subscriptions","organizations_url":"https://api.github.com/users/TechEmpower/orgs","repos_url":"https://api.github.com/users/TechEmpower/repos","events_url":"https://api.github.com/users/TechEmpower/events{/privacy}","received_events_url":"https://api.github.com/users/TechEmpower/received_events","type":"Organization","site_admin":false},"repo":{"id":8957264,"node_id":"MDEwOlJlcG9zaXRvcnk4OTU3MjY0","name":"FrameworkBenchmarks","full_name":"TechEmpower/FrameworkBenchmarks","owner":{"login":"TechEmpower","id":3910062,"node_id":"MDEyOk9yZ2FuaXphdGlvbjM5MTAwNjI=","avatar_url":"https://avatars2.githubusercontent.com/u/3910062?v=4","gravatar_id":"","url":"https://api.github.com/users/TechEmpower","html_url":"https://github.com/TechEmpower","followers_url":"https://api.github.com/users/TechEmpower/followers","following_url":"https://api.github.com/users/TechEmpower/following{/other_user}","gists_url":"https://api.github.com/users/TechEmpower/gists{/gist_id}","starred_url":"https://api.github.com/users/TechEmpower/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/TechEmpower/subscriptions","organizations_url":"https://api.github.com/users/TechEmpower/orgs","repos_url":"https://api.github.com/users/TechEmpower/repos","events_url":"https://api.github.com/users/TechEmpower/events{/privacy}","received_events_url":"https://api.github.com/users/TechEmpower/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/TechEmpower/FrameworkBenchmarks","description":"Source for the TechEmpower Framework Benchmarks project","fork":false,"url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks","forks_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/forks","keys_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/keys{/key_id}","collaborators_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/teams","hooks_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/hooks","issue_events_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/issues/events{/number}","events_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/events","assignees_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/assignees{/user}","branches_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/branches{/branch}","tags_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/tags","blobs_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/git/refs{/sha}","trees_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/git/trees{/sha}","statuses_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/statuses/{sha}","languages_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/languages","stargazers_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/stargazers","contributors_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/contributors","subscribers_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/subscribers","subscription_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/subscription","commits_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/commits{/sha}","git_commits_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/git/commits{/sha}","comments_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/comments{/number}","issue_comment_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/issues/comments{/number}","contents_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/contents/{+path}","compare_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/compare/{base}...{head}","merges_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/merges","archive_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/downloads","issues_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/issues{/number}","pulls_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/pulls{/number}","milestones_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/milestones{/number}","notifications_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/labels{/name}","releases_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/releases{/id}","deployments_url":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/deployments","created_at":"2013-03-22T17:33:54Z","updated_at":"2018-08-26T12:48:03Z","pushed_at":"2018-08-26T08:47:11Z","git_url":"git://github.com/TechEmpower/FrameworkBenchmarks.git","ssh_url":"git@github.com:TechEmpower/FrameworkBenchmarks.git","clone_url":"https://github.com/TechEmpower/FrameworkBenchmarks.git","svn_url":"https://github.com/TechEmpower/FrameworkBenchmarks","homepage":"https://www.techempower.com/benchmarks/","size":272784,"stargazers_count":3490,"watchers_count":3490,"language":"PHP","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":1107,"mirror_url":null,"archived":false,"open_issues_count":42,"license":{"key":"bsd-3-clause","name":"BSD 3-Clause \"New\" or \"Revised\" License","spdx_id":"BSD-3-Clause","url":"https://api.github.com/licenses/bsd-3-clause","node_id":"MDc6TGljZW5zZTU="},"forks":1107,"open_issues":42,"watchers":3490,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/pulls/4015"},"html":{"href":"https://github.com/TechEmpower/FrameworkBenchmarks/pull/4015"},"issue":{"href":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/issues/4015"},"comments":{"href":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/issues/4015/comments"},"review_comments":{"href":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/pulls/4015/comments"},"review_comment":{"href":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/pulls/4015/commits"},"statuses":{"href":"https://api.github.com/repos/TechEmpower/FrameworkBenchmarks/statuses/5b3cef95595d7690f9569173df6b7b9693e1f7a7"}},"author_association":"CONTRIBUTOR"}}
{"actor":{"display_login":"roji"}}