{"id":493,"date":"2008-03-28T12:05:21","date_gmt":"2008-03-28T11:05:21","guid":{"rendered":"http:\/\/soci.hu\/blog\/index.php\/2008\/03\/28\/mikor-es-hogyan-mukodik-a-minimal-logging-bulk-muveletek-az-sql-serverben\/"},"modified":"2008-03-28T12:15:33","modified_gmt":"2008-03-28T11:15:33","slug":"mikor-es-hogyan-mukodik-a-minimal-logging-bulk-muveletek-az-sql-serverben","status":"publish","type":"post","link":"https:\/\/soci.hu\/blog\/index.php\/2008\/03\/28\/mikor-es-hogyan-mukodik-a-minimal-logging-bulk-muveletek-az-sql-serverben\/","title":{"rendered":"Mikor \u00e9s hogyan m\u0171k\u00f6dik a Minimal Logging (bulk m\u0171veletek) az SQL Serverben?"},"content":{"rendered":"<p>Az k\u00f6zismert, hogy a BULK INSERT parancs \u00e9s a bcp.exe vagy az SqlBulkCopy oszt\u00e1ly gyorsabban tud adatokat bet\u00f6lteni egy t\u00e1bl\u00e1ba, mint a sima insert. M\u00e9r\u00e9seim szerint p\u00e1r 10x gyorsabban. Az\u00e9rt gyorsabb, mert nem minden sort logolnak, csak nagyobb allok\u00e1ci\u00f3s egys\u00e9geket. Eddig ez ok. Ami nem, hogy ez messze nem minden helyzetben megy, sokszor \u00e1tcsap teljesen logolt m\u0171k\u00f6d\u00e9sbe. Nem arra a trivi\u00e1ra gondolok, hogy Full Recovery modell eset\u00e9n \u00edgy m\u0171k\u00f6dik, az ok. Hanem az indexek is befoly\u00e1solj\u00e1k, hogy mikor lesz sim\u00e1n logolt egy m\u0171velet. Pl. ha van Clustered index a t\u00e1bl\u00e1n \u00e9s van benne adat, akkor nem lesz logolt a m\u0171velet, punktum!<br \/>\nTess\u00e9k megn\u00e9zni a <a href=\"http:\/\/blogs.msdn.com\/sqlserverstorageengine\/archive\/2008\/02\/05\/bulk-logging-optimizations-minimal-logging.aspx\">cikk v\u00e9g\u00e9n a t\u00e1bl\u00e1zatot<\/a>.<\/p>\n<p>Update: SQL Server 2008-ban ez is v\u00e1ltozik, majd \u00edrok r\u00f3la k\u00e9s\u0151bb. Legyen el\u00e9g annyi, hogy az insert-select is minim\u00e1lisan logolt lesz. :)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Az k\u00f6zismert, hogy a BULK INSERT parancs \u00e9s a bcp.exe vagy az SqlBulkCopy oszt\u00e1ly gyorsabban tud adatokat bet\u00f6lteni egy t\u00e1bl\u00e1ba, mint a&#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-493","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\/493","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=493"}],"version-history":[{"count":0,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/493\/revisions"}],"wp:attachment":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=493"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=493"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=493"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}