{"action":"closed","issue":{"url":"https://api.github.com/repos/jOOQ/jOOQ/issues/4642","labels_url":"https://api.github.com/repos/jOOQ/jOOQ/issues/4642/labels{/name}","comments_url":"https://api.github.com/repos/jOOQ/jOOQ/issues/4642/comments","events_url":"https://api.github.com/repos/jOOQ/jOOQ/issues/4642/events","html_url":"https://github.com/jOOQ/jOOQ/issues/4642","id":111952939,"number":4642,"title":"Significant schema mapping initialisation overhead when schema mapping isn't even used","user":{"login":"lukaseder","id":734593,"avatar_url":"https://avatars.githubusercontent.com/u/734593?v=3","gravatar_id":"","url":"https://api.github.com/users/lukaseder","html_url":"https://github.com/lukaseder","followers_url":"https://api.github.com/users/lukaseder/followers","following_url":"https://api.github.com/users/lukaseder/following{/other_user}","gists_url":"https://api.github.com/users/lukaseder/gists{/gist_id}","starred_url":"https://api.github.com/users/lukaseder/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lukaseder/subscriptions","organizations_url":"https://api.github.com/users/lukaseder/orgs","repos_url":"https://api.github.com/users/lukaseder/repos","events_url":"https://api.github.com/users/lukaseder/events{/privacy}","received_events_url":"https://api.github.com/users/lukaseder/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/jOOQ/jOOQ/labels/C:%20Functionality","name":"C: Functionality","color":"0000aa"},{"url":"https://api.github.com/repos/jOOQ/jOOQ/labels/P:%20High","name":"P: High","color":"ff6666"},{"url":"https://api.github.com/repos/jOOQ/jOOQ/labels/R:%20Fixed","name":"R: Fixed","color":"55ff55"},{"url":"https://api.github.com/repos/jOOQ/jOOQ/labels/T:%20Defect","name":"T: Defect","color":"cccccc"}],"state":"closed","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/jOOQ/jOOQ/milestones/119","html_url":"https://github.com/jOOQ/jOOQ/milestones/Version%203.8.0","labels_url":"https://api.github.com/repos/jOOQ/jOOQ/milestones/119/labels","id":1094772,"number":119,"title":"Version 3.8.0","description":"","creator":{"login":"lukaseder","id":734593,"avatar_url":"https://avatars.githubusercontent.com/u/734593?v=3","gravatar_id":"","url":"https://api.github.com/users/lukaseder","html_url":"https://github.com/lukaseder","followers_url":"https://api.github.com/users/lukaseder/followers","following_url":"https://api.github.com/users/lukaseder/following{/other_user}","gists_url":"https://api.github.com/users/lukaseder/gists{/gist_id}","starred_url":"https://api.github.com/users/lukaseder/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lukaseder/subscriptions","organizations_url":"https://api.github.com/users/lukaseder/orgs","repos_url":"https://api.github.com/users/lukaseder/repos","events_url":"https://api.github.com/users/lukaseder/events{/privacy}","received_events_url":"https://api.github.com/users/lukaseder/received_events","type":"User","site_admin":false},"open_issues":316,"closed_issues":12,"state":"open","created_at":"2015-05-04T10:29:41Z","updated_at":"2015-10-17T09:58:13Z","due_on":null,"closed_at":null},"comments":0,"created_at":"2015-10-17T09:28:05Z","updated_at":"2015-10-17T09:58:13Z","closed_at":"2015-10-17T09:58:13Z","body":"This is a finding from analyses made after a third-party benchmark comparing jOOQ with JDBC, Hibernate, Spring Data:\r\nhttps://github.com/nithril/sandbox-query-benchmark-jooq-hibernate-jdbc\r\n\r\nBenchmarks show that there is a significant overhead related to the initialisation of the `org.jooq.SchemaMapping` subsystem even when no schema mapping is used at all. The performance gain in wall clock time for heavy SQL rendering (generating and executing millions of trivial queries) that can be achieved by skipping the relevant code is around 10% - 15%."}}