{"action":"created","issue":{"url":"https://api.github.com/repos/brettwooldridge/HikariCP/issues/443","labels_url":"https://api.github.com/repos/brettwooldridge/HikariCP/issues/443/labels{/name}","comments_url":"https://api.github.com/repos/brettwooldridge/HikariCP/issues/443/comments","events_url":"https://api.github.com/repos/brettwooldridge/HikariCP/issues/443/events","html_url":"https://github.com/brettwooldridge/HikariCP/issues/443","id":109785875,"number":443,"title":"Performance : Hikari vs high concurrency tcServer ?","user":{"login":"abhimanyuvarma","id":14974606,"avatar_url":"https://avatars.githubusercontent.com/u/14974606?v=3","gravatar_id":"","url":"https://api.github.com/users/abhimanyuvarma","html_url":"https://github.com/abhimanyuvarma","followers_url":"https://api.github.com/users/abhimanyuvarma/followers","following_url":"https://api.github.com/users/abhimanyuvarma/following{/other_user}","gists_url":"https://api.github.com/users/abhimanyuvarma/gists{/gist_id}","starred_url":"https://api.github.com/users/abhimanyuvarma/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/abhimanyuvarma/subscriptions","organizations_url":"https://api.github.com/users/abhimanyuvarma/orgs","repos_url":"https://api.github.com/users/abhimanyuvarma/repos","events_url":"https://api.github.com/users/abhimanyuvarma/events{/privacy}","received_events_url":"https://api.github.com/users/abhimanyuvarma/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/brettwooldridge/HikariCP/labels/question","name":"question","color":"cc317c"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":19,"created_at":"2015-10-05T12:30:30Z","updated_at":"2015-12-07T13:12:26Z","closed_at":"2015-10-07T03:12:43Z","body":"We were trying to figure which CP should we go with ? We compared tomcat vs tcServer vs Hikari CP and we saw that HIkari CP performed much better than tomcat but when we compared the following transactions of HIkari CP against tcServer - \r\n1) getConnection\r\n2) getConnection, stored proc execution , connection.close\r\n\r\nThe average response times were every similar ,  with tcServer giving a more stable set of response times . The standard deviation of Hikari CP was more as compared to tcServer - with lesser number of spikes(min and max) over a period of time.\r\n![image](https://cloud.githubusercontent.com/assets/14974606/10280418/ba81033e-6b8a-11e5-9e2f-5270f8e1eded.png)\r\n\r\nAny thoughts ?\r\n"},"comment":{"url":"https://api.github.com/repos/brettwooldridge/HikariCP/issues/comments/162520381","html_url":"https://github.com/brettwooldridge/HikariCP/issues/443#issuecomment-162520381","issue_url":"https://api.github.com/repos/brettwooldridge/HikariCP/issues/443","id":162520381,"user":{"login":"mahendya","id":15936347,"avatar_url":"https://avatars.githubusercontent.com/u/15936347?v=3","gravatar_id":"","url":"https://api.github.com/users/mahendya","html_url":"https://github.com/mahendya","followers_url":"https://api.github.com/users/mahendya/followers","following_url":"https://api.github.com/users/mahendya/following{/other_user}","gists_url":"https://api.github.com/users/mahendya/gists{/gist_id}","starred_url":"https://api.github.com/users/mahendya/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mahendya/subscriptions","organizations_url":"https://api.github.com/users/mahendya/orgs","repos_url":"https://api.github.com/users/mahendya/repos","events_url":"https://api.github.com/users/mahendya/events{/privacy}","received_events_url":"https://api.github.com/users/mahendya/received_events","type":"User","site_admin":false},"created_at":"2015-12-07T13:12:26Z","updated_at":"2015-12-07T13:12:26Z","body":"@brettwooldridge just want know when hikari connection pool will be created in tcServer.\r\n1.)pool is created upon Tomcat startup ?\r\n2.)or  when it's first looked up in JNDI ?\r\n\r\nI am defining my resource in context.xml({CATALINA-BASE}/conf/Localhost/).\r\nIf it is during startup then is there any way to stop any resource loading/deployment during startup?\r\nActually i have two data source resources with two different connection pooling.\r\nwant to enable one at a time. please help."}}