{"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":16,"created_at":"2016-06-26T15:29:12Z","updated_at":"2016-07-13T11:39:26Z","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/232330586","html_url":"https://github.com/sualeh/SchemaCrawler/issues/79#issuecomment-232330586","issue_url":"https://api.github.com/repos/sualeh/SchemaCrawler/issues/79","id":232330586,"user":{"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},"created_at":"2016-07-13T11:39:26Z","updated_at":"2016-07-13T11:39:26Z","body":"Absolutely - use the `-url` argument. Please run SchemaCrawler wiht `-help` for details."}}
{"actor":{"display_login":"sualeh"}}