{"action":"created","issue":{"url":"https://api.github.com/repos/sualeh/SchemaCrawler/issues/79","repository_url":"https://api.github.com/repos/sualeh/SchemaCrawler","labels_url":"https://api.github.com/repos/sualeh/SchemaCrawler/issues/79/labels{/name}","comments_url":"https://api.github.com/repos/sualeh/SchemaCrawler/issues/79/comments","events_url":"https://api.github.com/repos/sualeh/SchemaCrawler/issues/79/events","html_url":"https://github.com/sualeh/SchemaCrawler/issues/79","id":162332523,"number":79,"title":"Performance issues when running on a DB with thousands of objects","user":{"login":"pyrocks","id":18515297,"avatar_url":"https://avatars.githubusercontent.com/u/18515297?v=3","gravatar_id":"","url":"https://api.github.com/users/pyrocks","html_url":"https://github.com/pyrocks","followers_url":"https://api.github.com/users/pyrocks/followers","following_url":"https://api.github.com/users/pyrocks/following{/other_user}","gists_url":"https://api.github.com/users/pyrocks/gists{/gist_id}","starred_url":"https://api.github.com/users/pyrocks/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pyrocks/subscriptions","organizations_url":"https://api.github.com/users/pyrocks/orgs","repos_url":"https://api.github.com/users/pyrocks/repos","events_url":"https://api.github.com/users/pyrocks/events{/privacy}","received_events_url":"https://api.github.com/users/pyrocks/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/sualeh/SchemaCrawler/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"open","locked":false,"assignee":{"login":"sualeh","id":58572,"avatar_url":"https://avatars.githubusercontent.com/u/58572?v=3","gravatar_id":"","url":"https://api.github.com/users/sualeh","html_url":"https://github.com/sualeh","followers_url":"https://api.github.com/users/sualeh/followers","following_url":"https://api.github.com/users/sualeh/following{/other_user}","gists_url":"https://api.github.com/users/sualeh/gists{/gist_id}","starred_url":"https://api.github.com/users/sualeh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sualeh/subscriptions","organizations_url":"https://api.github.com/users/sualeh/orgs","repos_url":"https://api.github.com/users/sualeh/repos","events_url":"https://api.github.com/users/sualeh/events{/privacy}","received_events_url":"https://api.github.com/users/sualeh/received_events","type":"User","site_admin":false},"assignees":[{"login":"sualeh","id":58572,"avatar_url":"https://avatars.githubusercontent.com/u/58572?v=3","gravatar_id":"","url":"https://api.github.com/users/sualeh","html_url":"https://github.com/sualeh","followers_url":"https://api.github.com/users/sualeh/followers","following_url":"https://api.github.com/users/sualeh/following{/other_user}","gists_url":"https://api.github.com/users/sualeh/gists{/gist_id}","starred_url":"https://api.github.com/users/sualeh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sualeh/subscriptions","organizations_url":"https://api.github.com/users/sualeh/orgs","repos_url":"https://api.github.com/users/sualeh/repos","events_url":"https://api.github.com/users/sualeh/events{/privacy}","received_events_url":"https://api.github.com/users/sualeh/received_events","type":"User","site_admin":false}],"milestone":null,"comments":19,"created_at":"2016-06-26T15:29:12Z","updated_at":"2016-07-13T12:42:24Z","closed_at":null,"body":"Hi Sualeh,\r\n\r\nIt's me again, sorry for not responding earlier, I've been out of work for the past 7 weeks.\r\nThe former 2 issues seems resolved, but I still have a severe performance issue running schema crawler on a large DB.\r\n\r\nFrom the queries it looks like you're fetching the info one table at a time, one procedure/function at a time etc., and since I have thousands of objects DB wide each such fetch takes a second or so and it consumes a lot of time.\r\nIs it possible that if no filters were used for table/procedure etc - you would fetch all the information needed in a single call per object type - and parse/correlate them by code?\r\n\r\nReason I'm asking is - I'm trying to automate generating an ERD for a schema in a large DB.\r\nif that won't finish in under 5 minutes (and it's far from that right now) - I'm back to the drawing board.\r\n\r\nThanks again,\r\nMor"},"comment":{"url":"https://api.github.com/repos/sualeh/SchemaCrawler/issues/comments/232343149","html_url":"https://github.com/sualeh/SchemaCrawler/issues/79#issuecomment-232343149","issue_url":"https://api.github.com/repos/sualeh/SchemaCrawler/issues/79","id":232343149,"user":{"login":"pyrocks","id":18515297,"avatar_url":"https://avatars.githubusercontent.com/u/18515297?v=3","gravatar_id":"","url":"https://api.github.com/users/pyrocks","html_url":"https://github.com/pyrocks","followers_url":"https://api.github.com/users/pyrocks/followers","following_url":"https://api.github.com/users/pyrocks/following{/other_user}","gists_url":"https://api.github.com/users/pyrocks/gists{/gist_id}","starred_url":"https://api.github.com/users/pyrocks/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pyrocks/subscriptions","organizations_url":"https://api.github.com/users/pyrocks/orgs","repos_url":"https://api.github.com/users/pyrocks/repos","events_url":"https://api.github.com/users/pyrocks/events{/privacy}","received_events_url":"https://api.github.com/users/pyrocks/received_events","type":"User","site_admin":false},"created_at":"2016-07-13T12:42:24Z","updated_at":"2016-07-13T12:42:24Z","body":"Great, please let me know as soon as you have something ready for testing.\r\nI'm sure it would reduce the times by more than half for the large DB.\r\n\r\nI may not contribute code, but I hope my inputs are still valuable :)\r\nIf this goes well and my managers approve adding this to our build process - you could add me and the company I work for to your \"who uses SchemaCrawler\" page :)"}}
{"actor":{"display_login":"pyrocks"}}