\uc694\uac74 \ud2b8\ub79c\uc7ad\uc158\uc5d0 \ubb38\uc81c\uac00 \uc0dd\uae30\uba74 waiting \ud558\uac70\ub098 rollback\ub418\ub294\ub370.
\n\uace0\uac78 \uac70\uce58\uc9c0 \uc54a\uace0 \ubb38\uc81c\uac00 \uc788\ub354\ub77c\ub3c4 \uace0\ub0e5 \uc77d\uc5b4\ubc84\ub9b0\ub2e4.
\n\uc5c5\ub370\uc774\ud2b8\ub098 writing\uc774 \ubb34\uc9c0 \ubc14\uc05c\uacf3\uc5d0\ub9cc \uc4f0\ub3c4\ub85d \ud558\uc790<\/p>\n
\uc544\uc6b8\ub7ec \ub9ac\uc2a4\ud2b8 \ud398\uc774\uc9c0\uc5d0\uc11c \ud544\uc694\ud55c \ub370\uc774\ud130\ub9cc select \ud560\uc218 \uc788\ub294 sql\ubb38\uc774\ub2e4.
\n\ubc14\ub85c\uc804\uc5d0 \uc62c\ub838\ub358\uac70\ub791 \ucabc\ub054 \ud2c0\ub9b0\ub370 \ucc28\uc774\uc810\uc744 \ube44\uad50\ud574 \ubcf4\uae30 \ubc14\ub780\ub2e4.
\n\uc544\ub798 \ubb38\uc7a5\uc774 \ucabc\ub054 \ub354 \ube60\ub974\ub2e4\uace0 \ud55c\ub2e4. <\/p>\n
set transaction isolation level read uncommitted
\nSelect Top [\uc6d0\ud558\ub294 \ub808\ucf54\ub4dc\uc218] a.*,b.writername,b.wlevel,b.mflag
\nFrom [\ud14c\uc774\ube14\uba85] a
\nLeft Outer Join Writer_Status b On a.id=b.memberid
\nWhere a.Idx In
\n\t(
\n\tSelect top [\uc6d0\ud558\ub294\ub808\ucf54\ub4dc\uc218] idx
\n\tFrom
\n\t\t(Select Top [\ub118\uc5b4\uc628\ud398\uc774\uc9c0*\uc6d0\ud558\ub294\ub808\ucf54\ub4dc\uc218] idx,ref,stp,recommand,sorting,rcnt
\n\t\tFrom [\ud14c\uc774\ube14\uba85]
\n\t\tOrder By ref desc, stp asc ) a
\n\tOrder By ref asc, stp desc
\n\t)
\norder By a.ref desc, stp asc <\/p>\n","protected":false},"excerpt":{"rendered":"
\uc694\uac74 \ud2b8\ub79c\uc7ad\uc158\uc5d0 \ubb38\uc81c\uac00 \uc0dd\uae30\uba74 waiting \ud558\uac70\ub098 rollback\ub418\ub294\ub370. \uace0\uac78 \uac70\uce58\uc9c0 \uc54a\uace0 \ubb38\uc81c\uac00 \uc788\ub354\ub77c\ub3c4 \uace0\ub0e5 \uc77d\uc5b4\ubc84\ub9b0\ub2e4. \uc5c5\ub370\uc774\ud2b8\ub098 writing\uc774 \ubb34\uc9c0 \ubc14\uc05c\uacf3\uc5d0\ub9cc \uc4f0\ub3c4\ub85d \ud558\uc790 \uc544\uc6b8\ub7ec \ub9ac\uc2a4\ud2b8 \ud398\uc774\uc9c0\uc5d0\uc11c \ud544\uc694\ud55c \ub370\uc774\ud130\ub9cc select \ud560\uc218 \uc788\ub294 sql\ubb38\uc774\ub2e4. \ubc14\ub85c\uc804\uc5d0 \uc62c\ub838\ub358\uac70\ub791 \ucabc\ub054 \ud2c0\ub9b0\ub370 \ucc28\uc774\uc810\uc744 \ube44\uad50\ud574 \ubcf4\uae30 \ubc14\ub780\ub2e4. \uc544\ub798 \ubb38\uc7a5\uc774 \ucabc\ub054 \ub354 \ube60\ub974\ub2e4\uace0 \ud55c\ub2e4. set transaction isolation level read uncommitted Select Top [\uc6d0\ud558\ub294 \ub808\ucf54\ub4dc\uc218] a.*,b.writername,b.wlevel,b.mflag From … \uacc4\uc18d \uc77d\uae30 “[asp] \ud0ec\ud50c\ub9bf\ud30c\uc77c\ub85c \uc11c\ube0c\ub514\ub809\ud1a0\ub9ac\uc758 \uac19\uc740 \ud30c\uc77c\uc744 \ud55c\ubc88\uc5d0 \uc218\uc815\ud558\ub294 sub() \ud568\uc218”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1408","post","type-post","status-publish","format-standard","hentry","category-tip"],"_links":{"self":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1408","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1408"}],"version-history":[{"count":0,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1408\/revisions"}],"wp:attachment":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1408"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1408"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1408"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}