{"id":771,"date":"2009-02-23T11:23:06","date_gmt":"2009-02-23T10:23:06","guid":{"rendered":"http:\/\/soci.hu\/blog\/?p=771"},"modified":"2009-02-23T11:23:06","modified_gmt":"2009-02-23T10:23:06","slug":"net-teljesitmenyhangolasi-tapasztalatok-6","status":"publish","type":"post","link":"https:\/\/soci.hu\/blog\/index.php\/2009\/02\/23\/net-teljesitmenyhangolasi-tapasztalatok-6\/","title":{"rendered":".NET teljes\u00edtm\u00e9nyhangol\u00e1si tapasztalatok 6."},"content":{"rendered":"<p>A Connection Poolr\u00f3l m\u00e9g p\u00e1r gondolat. J\u00f3, hogy van ez a pool, meg gyors\u00edt is, \u00f6r\u00fcl\u00fcnk neki, f\u0151leg webalkalmaz\u00e1sokban. Olyan appokban viszont, ahol \u00e1lland\u00f3an futnak a dolgaink, mint egy asztali alkalmaz\u00e1s eset\u00e9n, nem biztos, hogy \u00e9rdemes moh\u00f3n nyitni-z\u00e1rni a kapcsolatot.<br \/>\nA t\u0151zsdei keresked\u00e9si algoritmusaim backtestje sor\u00e1n sok sz\u00e1zezer param\u00e9terkombin\u00e1ci\u00f3t n\u00e9z v\u00e9gig a g\u00e9p, pr\u00f3b\u00e1lja meghat\u00e1rozni a legval\u00f3sz\u00edn\u0171bb nyer\u00e9si es\u00e9ly\u0171t vagy legnagyobb profit\/sz\u00f3r\u00e1ssal rendelkez\u0151t (enn\u00e9l j\u00f3val bonyolultabb a dolog, de ez most nem t\u0151zsd\u00e9s bejegyz\u00e9s lesz).<br \/>\nA DAL-t \u00fagy \u00edrtam meg ahogy webalkalmaz\u00e1sokban megszoktam, \u00edgy minden egyes trade ment\u00e9s\u00e9n\u00e9l nyitottam-z\u00e1rtam a connectiont. Profilerrel megn\u00e9zve kider\u00fclt, hogy a pool ellen\u00e9re is a fut\u00e1si id\u0151 harmada az open\/close-zal ment el. Emiatt k\u00e9sz\u00edtettem k\u00e9tf\u00e9le SqlHelper oszt\u00e1lyt, az egyik \u00e1lland\u00f3an nyitott kapcsolattal m\u0171k\u00f6dik, a m\u00e1sik az egy\u00e9b helyekre nyit-z\u00e1r mind eddig.<br \/>\n\u00d6sszegezve, a connection pool kiv\u00e1l\u00f3 dolog pillanatokra fut\u00f3 alkalmaz\u00e1sokhoz, mint a webalkalmaz\u00e1sok, de nem \u00e9rdemes er\u0151ltetni, ha t\u00f6bb sz\u00e1zezerszer kell nyitni-z\u00e1rni a kapcsolatot.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A Connection Poolr\u00f3l m\u00e9g p\u00e1r gondolat. J\u00f3, hogy van ez a pool, meg gyors\u00edt is, \u00f6r\u00fcl\u00fcnk neki, f\u0151leg webalkalmaz\u00e1sokban. Olyan appokban viszont,&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,25,6,70,4,30,21,58],"tags":[],"class_list":["post-771","post","type-post","status-publish","format-standard","hentry","category-net","category-adonet","category-adatbazisok","category-optimalizalas","category-szakmai-elet","category-sql-server","category-sql-server-2005","category-sql-server-2008"],"_links":{"self":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/771","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=771"}],"version-history":[{"count":2,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/771\/revisions"}],"predecessor-version":[{"id":808,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/771\/revisions\/808"}],"wp:attachment":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=771"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=771"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=771"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}