{"action":"created","issue":{"url":"https://api.github.com/repos/nlewo/nixpkgs-contrail/issues/37","repository_url":"https://api.github.com/repos/nlewo/nixpkgs-contrail","labels_url":"https://api.github.com/repos/nlewo/nixpkgs-contrail/issues/37/labels{/name}","comments_url":"https://api.github.com/repos/nlewo/nixpkgs-contrail/issues/37/comments","events_url":"https://api.github.com/repos/nlewo/nixpkgs-contrail/issues/37/events","html_url":"https://github.com/nlewo/nixpkgs-contrail/pull/37","id":383503621,"node_id":"MDExOlB1bGxSZXF1ZXN0MjMyOTU0MTU2","number":37,"title":"[WIP] modules.databaseLoader: improve CSV loading time","user":{"login":"eonpatapon","id":418227,"node_id":"MDQ6VXNlcjQxODIyNw==","avatar_url":"https://avatars1.githubusercontent.com/u/418227?v=4","gravatar_id":"","url":"https://api.github.com/users/eonpatapon","html_url":"https://github.com/eonpatapon","followers_url":"https://api.github.com/users/eonpatapon/followers","following_url":"https://api.github.com/users/eonpatapon/following{/other_user}","gists_url":"https://api.github.com/users/eonpatapon/gists{/gist_id}","starred_url":"https://api.github.com/users/eonpatapon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/eonpatapon/subscriptions","organizations_url":"https://api.github.com/users/eonpatapon/orgs","repos_url":"https://api.github.com/users/eonpatapon/repos","events_url":"https://api.github.com/users/eonpatapon/events{/privacy}","received_events_url":"https://api.github.com/users/eonpatapon/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-11-22T11:56:45Z","updated_at":"2018-11-22T15:37:15Z","closed_at":null,"author_association":"COLLABORATOR","pull_request":{"url":"https://api.github.com/repos/nlewo/nixpkgs-contrail/pulls/37","html_url":"https://github.com/nlewo/nixpkgs-contrail/pull/37","diff_url":"https://github.com/nlewo/nixpkgs-contrail/pull/37.diff","patch_url":"https://github.com/nlewo/nixpkgs-contrail/pull/37.patch"},"body":"Using prd2 DB\r\n\r\n```\r\nMAXBATCHSIZE = 2 / 267813 rows imported from 1 files in 1 minute and 22.795 seconds (0 skipped).\r\n\r\nbatch_size_warn_threshold_in_kb: 50\r\nbatch_size_fail_threshold_in_kb: 150\r\n\r\nMAXBATCHSIZE = 5 / 267813 rows imported from 1 files in 47.402 seconds (0 skipped).\r\nMAXBATCHSIZE = 5 / CHUNKSIZE = 2000 / 267813 rows imported from 1 files in 48.387 seconds (0 skipped).\r\nMAXBATCHSIZE = 7 / 267813 rows imported from 1 files in 45.286 seconds (0 skipped).\r\n\r\nMAXBATCHSIZE = 10 / 267813 rows imported from 1 files in 34.972 seconds (0 skipped).\r\n\r\nbatch_size_warn_threshold_in_kb: 200\r\nbatch_size_fail_threshold_in_kb: 500\r\n\r\nMAXBATCHSIZE = 20 / 267813 rows imported from 1 files in 24.408 seconds (0 skipped).\r\n\r\nbatch_size_warn_threshold_in_kb: 500\r\nbatch_size_fail_threshold_in_kb: 1000\r\n\r\nMAXBATCHSIZE = 30 / 267813 rows imported from 1 files in 23.937 seconds (0 skipped).\r\nMAXBATCHSIZE = 40 / 267813 rows imported from 1 files in 19.950 seconds (0 skipped).\r\nMAXBATCHSIZE = 50 / 267813 rows imported from 1 files in 18.198 seconds (0 skipped).\r\nMAXBATCHSIZE = 60 / 267813 rows imported from 1 files in 22.443 seconds (0 skipped).\r\n```\r\n"},"comment":{"url":"https://api.github.com/repos/nlewo/nixpkgs-contrail/issues/comments/441065223","html_url":"https://github.com/nlewo/nixpkgs-contrail/pull/37#issuecomment-441065223","issue_url":"https://api.github.com/repos/nlewo/nixpkgs-contrail/issues/37","id":441065223,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0MTA2NTIyMw==","user":{"login":"eonpatapon","id":418227,"node_id":"MDQ6VXNlcjQxODIyNw==","avatar_url":"https://avatars1.githubusercontent.com/u/418227?v=4","gravatar_id":"","url":"https://api.github.com/users/eonpatapon","html_url":"https://github.com/eonpatapon","followers_url":"https://api.github.com/users/eonpatapon/followers","following_url":"https://api.github.com/users/eonpatapon/following{/other_user}","gists_url":"https://api.github.com/users/eonpatapon/gists{/gist_id}","starred_url":"https://api.github.com/users/eonpatapon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/eonpatapon/subscriptions","organizations_url":"https://api.github.com/users/eonpatapon/orgs","repos_url":"https://api.github.com/users/eonpatapon/repos","events_url":"https://api.github.com/users/eonpatapon/events{/privacy}","received_events_url":"https://api.github.com/users/eonpatapon/received_events","type":"User","site_admin":false},"created_at":"2018-11-22T15:37:15Z","updated_at":"2018-11-22T15:37:15Z","author_association":"COLLABORATOR","body":"No more errors\r\n\r\n```\r\n852037 rows imported from 1 files in 1 minute and 7.389 seconds (0 skipped).\r\n```"}}
{"actor":{"display_login":"eonpatapon"}}