{"action":"created","issue":{"url":"https://api.github.com/repos/pekim/tedious/issues/303","repository_url":"https://api.github.com/repos/pekim/tedious","labels_url":"https://api.github.com/repos/pekim/tedious/issues/303/labels{/name}","comments_url":"https://api.github.com/repos/pekim/tedious/issues/303/comments","events_url":"https://api.github.com/repos/pekim/tedious/issues/303/events","html_url":"https://github.com/pekim/tedious/issues/303","id":102081670,"number":303,"title":"Major Performance Regression with 1.12 generator based stream parsing","user":{"login":"jeremydiviney","id":5009664,"avatar_url":"https://avatars.githubusercontent.com/u/5009664?v=3","gravatar_id":"","url":"https://api.github.com/users/jeremydiviney","html_url":"https://github.com/jeremydiviney","followers_url":"https://api.github.com/users/jeremydiviney/followers","following_url":"https://api.github.com/users/jeremydiviney/following{/other_user}","gists_url":"https://api.github.com/users/jeremydiviney/gists{/gist_id}","starred_url":"https://api.github.com/users/jeremydiviney/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jeremydiviney/subscriptions","organizations_url":"https://api.github.com/users/jeremydiviney/orgs","repos_url":"https://api.github.com/users/jeremydiviney/repos","events_url":"https://api.github.com/users/jeremydiviney/events{/privacy}","received_events_url":"https://api.github.com/users/jeremydiviney/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/pekim/tedious/labels/bug","name":"bug","color":"e10c02"},{"url":"https://api.github.com/repos/pekim/tedious/labels/discussion","name":"discussion","color":"bfd4f2"}],"state":"open","locked":false,"assignee":{"login":"arthurschreiber","id":2195,"avatar_url":"https://avatars.githubusercontent.com/u/2195?v=3","gravatar_id":"","url":"https://api.github.com/users/arthurschreiber","html_url":"https://github.com/arthurschreiber","followers_url":"https://api.github.com/users/arthurschreiber/followers","following_url":"https://api.github.com/users/arthurschreiber/following{/other_user}","gists_url":"https://api.github.com/users/arthurschreiber/gists{/gist_id}","starred_url":"https://api.github.com/users/arthurschreiber/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/arthurschreiber/subscriptions","organizations_url":"https://api.github.com/users/arthurschreiber/orgs","repos_url":"https://api.github.com/users/arthurschreiber/repos","events_url":"https://api.github.com/users/arthurschreiber/events{/privacy}","received_events_url":"https://api.github.com/users/arthurschreiber/received_events","type":"User","site_admin":false},"milestone":null,"comments":7,"created_at":"2015-08-20T07:41:58Z","updated_at":"2016-02-20T14:16:26Z","closed_at":null,"body":"When executing an sql statement that returns a non-trivial number of rows (500+),  that last releases that uses the babel runtime, are performing about 20 times slower than the previous (1.11.4) and older builds.\r\n\r\nI have run the node-inspector and it seems to be due to a huge increase in the cpu utilization while fetching rows, and most of that cpu time is spent in babel runtime calls.\r\n\r\nFor example I tested fetching about 20,000 rows with about 25 columns of int,nvarchar,bit types, and on the older versions the data is returned in just about 1000ms (which is just about the same as it return in SQL management studio).... In the latest couple versions, is it taking well over 25 seconds(25,000ms).  \r\n\r\nWe are seeing the same performance regression on all types of queries...\r\n\r\nThis seems like a major issue, that needs to be address very soon"},"comment":{"url":"https://api.github.com/repos/pekim/tedious/issues/comments/186613538","html_url":"https://github.com/pekim/tedious/issues/303#issuecomment-186613538","issue_url":"https://api.github.com/repos/pekim/tedious/issues/303","id":186613538,"user":{"login":"arthurschreiber","id":2195,"avatar_url":"https://avatars.githubusercontent.com/u/2195?v=3","gravatar_id":"","url":"https://api.github.com/users/arthurschreiber","html_url":"https://github.com/arthurschreiber","followers_url":"https://api.github.com/users/arthurschreiber/followers","following_url":"https://api.github.com/users/arthurschreiber/following{/other_user}","gists_url":"https://api.github.com/users/arthurschreiber/gists{/gist_id}","starred_url":"https://api.github.com/users/arthurschreiber/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/arthurschreiber/subscriptions","organizations_url":"https://api.github.com/users/arthurschreiber/orgs","repos_url":"https://api.github.com/users/arthurschreiber/repos","events_url":"https://api.github.com/users/arthurschreiber/events{/privacy}","received_events_url":"https://api.github.com/users/arthurschreiber/received_events","type":"User","site_admin":false},"created_at":"2016-02-20T14:16:26Z","updated_at":"2016-02-20T14:16:26Z","body":"@kjvalencik Partially, yes. The parser was changed to not use any generator functions anymore. There's still a few areas left where performance can be improved, but that work is not finished yet. Overall, performance will largely depend on your use cases."}}