{"action":"created","issue":{"url":"https://api.github.com/repos/mattn/go-oci8/issues/99","repository_url":"https://api.github.com/repos/mattn/go-oci8","labels_url":"https://api.github.com/repos/mattn/go-oci8/issues/99/labels{/name}","comments_url":"https://api.github.com/repos/mattn/go-oci8/issues/99/comments","events_url":"https://api.github.com/repos/mattn/go-oci8/issues/99/events","html_url":"https://github.com/mattn/go-oci8/issues/99","id":154441552,"number":99,"title":"The performance is defeated by gopkg.in/goracle.v1 (similar as python cx_Oracle)","user":{"login":"yourchanges","id":492946,"avatar_url":"https://avatars.githubusercontent.com/u/492946?v=3","gravatar_id":"","url":"https://api.github.com/users/yourchanges","html_url":"https://github.com/yourchanges","followers_url":"https://api.github.com/users/yourchanges/followers","following_url":"https://api.github.com/users/yourchanges/following{/other_user}","gists_url":"https://api.github.com/users/yourchanges/gists{/gist_id}","starred_url":"https://api.github.com/users/yourchanges/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yourchanges/subscriptions","organizations_url":"https://api.github.com/users/yourchanges/orgs","repos_url":"https://api.github.com/users/yourchanges/repos","events_url":"https://api.github.com/users/yourchanges/events{/privacy}","received_events_url":"https://api.github.com/users/yourchanges/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-05-12T09:50:55Z","updated_at":"2016-07-07T16:16:25Z","closed_at":null,"body":"Hi,\r\n\r\nI have write a simple code to fetch the **2000000** rows from table use three golang oracle driver:\r\n\r\n- gopkg.in/goracle.v1                  **==> about 22 seconds**\r\n- github.com/mattn/go-oci8        **==> about 34 seconds**\r\n- gopkg.in/rana/ora.v3                **==> about 660 seconds**\r\n\r\n(Note：the python cx_Oracle only takes 18 seconds to do the same thing)\r\n\r\n**My ENV:**\r\ncentos 6.6 64bit\r\ngolang 1.5.3\r\n\r\n**The code:**\r\n\r\n`func FetchData(db *sql.DB) []int {\r\n\r\n\tvar r []int\r\n\r\n\tsqlstr := `SELECT id FROM xxxx.geolocation`\r\n\r\n\t// Prepare statement for reading data\r\n\tstmtOut, err := db.Prepare(sqlstr)\r\n\tcheckErr(err)\r\n\tdefer stmtOut.Close()\r\n\r\n\trows, err := stmtOut.Query()\r\n\tcheckErr(err)\r\n\r\n\tfor rows.Next() {\r\n\t\tvar id int\r\n\t\terr = rows.Scan(&id)\r\n\t\tcheckErr(err)\r\n\t\tr = append(r, id)\r\n\t}\r\n\treturn r\r\n}`"},"comment":{"url":"https://api.github.com/repos/mattn/go-oci8/issues/comments/231129496","html_url":"https://github.com/mattn/go-oci8/issues/99#issuecomment-231129496","issue_url":"https://api.github.com/repos/mattn/go-oci8/issues/99","id":231129496,"user":{"login":"drewwells","id":239123,"avatar_url":"https://avatars.githubusercontent.com/u/239123?v=3","gravatar_id":"","url":"https://api.github.com/users/drewwells","html_url":"https://github.com/drewwells","followers_url":"https://api.github.com/users/drewwells/followers","following_url":"https://api.github.com/users/drewwells/following{/other_user}","gists_url":"https://api.github.com/users/drewwells/gists{/gist_id}","starred_url":"https://api.github.com/users/drewwells/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/drewwells/subscriptions","organizations_url":"https://api.github.com/users/drewwells/orgs","repos_url":"https://api.github.com/users/drewwells/repos","events_url":"https://api.github.com/users/drewwells/events{/privacy}","received_events_url":"https://api.github.com/users/drewwells/received_events","type":"User","site_admin":false},"created_at":"2016-07-07T16:16:25Z","updated_at":"2016-07-07T16:16:25Z","body":"gooracle is discontinued and likely crashes under concurrent loads. If your intention is to improve performance of go-oci8, a benchmark test and sample data would help improve performance of this driver."}}
{"actor":{"display_login":"drewwells"}}