{"action":"created","issue":{"url":"https://api.github.com/repos/silverstripe/silverstripe-framework/issues/4143","labels_url":"https://api.github.com/repos/silverstripe/silverstripe-framework/issues/4143/labels{/name}","comments_url":"https://api.github.com/repos/silverstripe/silverstripe-framework/issues/4143/comments","events_url":"https://api.github.com/repos/silverstripe/silverstripe-framework/issues/4143/events","html_url":"https://github.com/silverstripe/silverstripe-framework/pull/4143","id":72021112,"number":4143,"title":"API Use unbuffered MySQL Prepared statements by default","user":{"login":"tractorcow","id":936064,"avatar_url":"https://avatars.githubusercontent.com/u/936064?v=3","gravatar_id":"","url":"https://api.github.com/users/tractorcow","html_url":"https://github.com/tractorcow","followers_url":"https://api.github.com/users/tractorcow/followers","following_url":"https://api.github.com/users/tractorcow/following{/other_user}","gists_url":"https://api.github.com/users/tractorcow/gists{/gist_id}","starred_url":"https://api.github.com/users/tractorcow/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tractorcow/subscriptions","organizations_url":"https://api.github.com/users/tractorcow/orgs","repos_url":"https://api.github.com/users/tractorcow/repos","events_url":"https://api.github.com/users/tractorcow/events{/privacy}","received_events_url":"https://api.github.com/users/tractorcow/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/silverstripe/silverstripe-framework/labels/impact/critical","name":"impact/critical","color":"d7e102"},{"url":"https://api.github.com/repos/silverstripe/silverstripe-framework/labels/in%20progress","name":"in progress","color":"ededed"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/silverstripe/silverstripe-framework/milestones/6","html_url":"https://github.com/silverstripe/silverstripe-framework/milestones/3.2%20alpha%201","labels_url":"https://api.github.com/repos/silverstripe/silverstripe-framework/milestones/6/labels","id":598743,"number":6,"title":"3.2 alpha 1","description":"Things that we want to have fixed/added in time for the first alpha of 3.2.","creator":{"login":"simonwelsh","id":125915,"avatar_url":"https://avatars.githubusercontent.com/u/125915?v=3","gravatar_id":"","url":"https://api.github.com/users/simonwelsh","html_url":"https://github.com/simonwelsh","followers_url":"https://api.github.com/users/simonwelsh/followers","following_url":"https://api.github.com/users/simonwelsh/following{/other_user}","gists_url":"https://api.github.com/users/simonwelsh/gists{/gist_id}","starred_url":"https://api.github.com/users/simonwelsh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/simonwelsh/subscriptions","organizations_url":"https://api.github.com/users/simonwelsh/orgs","repos_url":"https://api.github.com/users/simonwelsh/repos","events_url":"https://api.github.com/users/simonwelsh/events{/privacy}","received_events_url":"https://api.github.com/users/simonwelsh/received_events","type":"User","site_admin":false},"open_issues":9,"closed_issues":23,"state":"open","created_at":"2014-03-15T20:45:38Z","updated_at":"2015-04-30T00:01:52Z","due_on":null,"closed_at":null},"comments":4,"created_at":"2015-04-30T00:00:15Z","updated_at":"2015-05-03T21:25:09Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/silverstripe/silverstripe-framework/pulls/4143","html_url":"https://github.com/silverstripe/silverstripe-framework/pull/4143","diff_url":"https://github.com/silverstripe/silverstripe-framework/pull/4143.diff","patch_url":"https://github.com/silverstripe/silverstripe-framework/pull/4143.patch"},"body":"This solution avoids the usage of any MySQL Native Driver specific API, so it should work with libmysql. \r\n\r\nUsing unbuffered SQL Statements should give a general performance increase, but we still use an internal buffer to support seek operations, or in cases where subsequent statements need to be prepared and require existing statements to release resources.\r\n\r\nThe non-prepared DB::query will still use the existing MySQLQuery object, but it has been stripped down a bit.\r\n\r\nFixes #3426"},"comment":{"url":"https://api.github.com/repos/silverstripe/silverstripe-framework/issues/comments/98545956","html_url":"https://github.com/silverstripe/silverstripe-framework/pull/4143#issuecomment-98545956","issue_url":"https://api.github.com/repos/silverstripe/silverstripe-framework/issues/4143","id":98545956,"user":{"login":"tractorcow","id":936064,"avatar_url":"https://avatars.githubusercontent.com/u/936064?v=3","gravatar_id":"","url":"https://api.github.com/users/tractorcow","html_url":"https://github.com/tractorcow","followers_url":"https://api.github.com/users/tractorcow/followers","following_url":"https://api.github.com/users/tractorcow/following{/other_user}","gists_url":"https://api.github.com/users/tractorcow/gists{/gist_id}","starred_url":"https://api.github.com/users/tractorcow/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tractorcow/subscriptions","organizations_url":"https://api.github.com/users/tractorcow/orgs","repos_url":"https://api.github.com/users/tractorcow/repos","events_url":"https://api.github.com/users/tractorcow/events{/privacy}","received_events_url":"https://api.github.com/users/tractorcow/received_events","type":"User","site_admin":false},"created_at":"2015-05-03T21:25:09Z","updated_at":"2015-05-03T21:25:09Z","body":"It's technically marked as \"done\". This is just bugfixing to that."}}