{"id":892,"date":"2009-08-04T11:21:42","date_gmt":"2009-08-04T10:21:42","guid":{"rendered":"http:\/\/soci.hu\/blog\/?p=892"},"modified":"2009-08-04T11:21:42","modified_gmt":"2009-08-04T10:21:42","slug":"deadlock-bulk-load-soran","status":"publish","type":"post","link":"https:\/\/soci.hu\/blog\/index.php\/2009\/08\/04\/deadlock-bulk-load-soran\/","title":{"rendered":"Deadlock bulk load sor\u00e1n"},"content":{"rendered":"<p>P\u00e1rhuzamos bulk bet\u00f6lt\u00e9sek eset\u00e9n deadlockolhatnak egym\u00e1ssal a m\u00e1sol\u00f3 sz\u00e1lak, f\u0151leg, ha vannak FK-ek a t\u00e1bl\u00e1kon.<\/p>\n<p>Sokf\u00e9le megold\u00e1s adhat\u00f3 a probl\u00e9m\u00e1ra.<br \/>\n1. \u00c1tmeneti t\u00e1bl\u00e1ba t\u00f6lt\u00fcnk, amin nincsenek indexek \u00e9s fk-k.<br \/>\n2. Lekezelj\u00fck a deadlockot, \u00e9s ism\u00e9tl\u00fcnk.<br \/>\n3. tablock-kal t\u00f6lt\u00fcnk be, ezzel azonban s\u00falyosan visszavethetj\u00fck a p\u00e1rhuzamoss\u00e1got.<br \/>\nEzt ki lehet k\u00e9nyszer\u00edteni k\u00f6zpontilag is:<br \/>\nEXEC sp_tableoption &#8216;Tick&#8217;, &#8216;table lock on bulk load&#8217;, &#8216;1&#8217;<\/p>\n<p>Nekem ez j\u00f3 volt, mert n\u00e1lam az adatforr\u00e1s volt lass\u00fa 1 sz\u00e1lon, ez\u00e9rt kellett 40, az SQL bet\u00f6lt\u00e9sek soros\u00edtva is el\u00e9g gyorsak, \u00e9s nincs deadlock.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>P\u00e1rhuzamos bulk bet\u00f6lt\u00e9sek eset\u00e9n deadlockolhatnak egym\u00e1ssal a m\u00e1sol\u00f3 sz\u00e1lak, f\u0151leg, ha vannak FK-ek a t\u00e1bl\u00e1kon. Sokf\u00e9le megold\u00e1s adhat\u00f3 a probl\u00e9m\u00e1ra. 1. \u00c1tmeneti&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,4,30,21,58],"tags":[],"class_list":["post-892","post","type-post","status-publish","format-standard","hentry","category-adatbazisok","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\/892","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=892"}],"version-history":[{"count":1,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/892\/revisions"}],"predecessor-version":[{"id":893,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/892\/revisions\/893"}],"wp:attachment":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=892"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=892"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=892"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}