[{"no":"688","minus":"-1555301707","minus_like_count":"-1","parent_post_comment_no":"0","post_no":"400","board_id":"","type":"","is_post_reply":"Y","user_no":"21","user_nickname":"kimho","user_thumb_url":"https:\/\/devsnote.com\/assets\/data\/profile\/21_0c1c96f4dcaef06e630a5d864ead1e67.jpg?u=1683208053","user_description":"","title":"[\ub2f5\ubcc0]isolation \uacfc with nolock \uad00\uacc4","comment":"

DB\ub97c \ud1b5\ud574\uc11c \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\uac70\ub098(SELECT), \uc800\uc7a5\/\ubcc0\uacbd\/\uc0ad\uc81c(INSERT,UPDATE,DELETE)\ub97c \ud560 \uc218 \uc788\ub294\ub370<\/p>\n\n

\ud558\ub098\uc758 DB\uc5d0 \uc5ec\ub7ec \uc0ac\ub78c\ub4e4\uc774 \uc811\uc18d\ud574\uc11c \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\uac70\ub098 \ubcc0\uacbd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n

<\/p>\n\n

\uadf8\ub7f0\ub370 \ub3d9\uc2dc\uc5d0 \uc5ec\ub7ec \uc0ac\ub78c\uc774 \ud558\ub098\uc758 DB\uc5d0 \uc811\uc18d\ud558\ub2e4\ubcf4\uba74 \ub3d9\uc2dc\uc131\uc758 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud569\ub2c8\ub2e4.<\/p>\n\n

\uc608\ub97c \ub4e4\uba74, \uc5b4\ub5a4 \uc811\uc18d\uc5d0 \uc758\ud574 \ub370\uc774\ud130\uac00 \ubcc0\uacbd\ub418\uace0 \uc788\ub294\ub370 \ubcc0\uacbd\ub418\uace0 \uc788\ub294 \ubc14\ub85c \uadf8 \uc9e7\uc740 \uc21c\uac04\uc5d0<\/p>\n\n

\ub204\uad70\uac00\uac00 \ub370\uc774\ud130\ub97c \uc77d\uc744 \ub54c \uc544\uc9c1 \ubcc0\uacbd\uc774 \uc644\ub8cc\ub418\uc9c0 \uc54a\uc740 \uc815\ud655\ud558\uc9c0 \uc54a\uc740 \ub370\uc774\ud130\ub97c \uc77d\uc5b4\uc628\ub2e4\ub4e0\uac00 \ud558\ub294 \ub4f1\uc758 \uacbd\uc6b0\uac00 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n

<\/p>\n\n

\uc774\ub7f0 \ubb38\uc81c\ub97c \ubc29\uc9c0\ud558\uae30 \uc704\ud574 MS SQL\uc5d0\uc11c\ub294 \ud558\ub098\uc758 \uc811\uc18d\uc774 \ud2b9\uc815 \uc791\uc5c5\uc744 \ud558\ub294 \ub3d9\uc548 \ub2e4\ub978 \uc791\uc5c5\uc744 \ubabb\ud558\ub3c4\ub85d isolation<\/span>(\uc77c\uad00\uc131)\uc774 \uac78\ub9ac\ub3c4\ub85d \ub418\uc5b4\uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n

\uc989, \ud558\ub098\uc758 \uc811\uc18d\uc774 \ub370\uc774\ud130\ub97c \ubcc0\uacbd\ud558\ub294 \uc791\uc5c5\uc744 \uc644\uc804\ud788 \ub05d\ub0bc \ub54c\uae4c\uc9c0 \ub2e4\ub978 \uc811\uc18d\uc774 \ub370\uc774\ud130\ub97c \uc77d\uc744 \uc218 \uc5c6\ub3c4\ub85d \ud558\ub294 \uac83\uc774 \uae30\ubcf8 \uac12\uc778\ub370<\/p>\n\n

\uc774 \uc218\uc900\uc758 isolation\uc744 READ COMMITED<\/span>\ub77c\uace0 \ud569\ub2c8\ub2e4.<\/p>\n\n

\ub2e4\uc2dc \ub9d0\ud574, \ub370\uc774\ud130\uac00 COMMITED(\ubcc0\uacbd \uc791\uc5c5 \uc644\ub8cc)\ub41c \uacbd\uc6b0\uc5d0\ub9cc \uc870\ud68c\ub97c \ud560 \uc218 \uc788\ub3c4\ub85d \ud558\uace0<\/p>\n\n

\uadf8\ub807\uc9c0 \uc54a\uc73c\uba74 COMMITED\ub418\uae30 \uc804\uae4c\uc9c0\ub294 \uc811\uc18d\uc5d0 LOCK\uc744 \uac78\uc5b4\uc11c \uae30\ub2e4\ub9ac\uac8c \ub9cc\ub4ed\ub2c8\ub2e4.<\/p>\n\n

<\/p>\n\n

\uadf8\ub7f0\ub370 \ub54c\ub85c\ub294 \ub370\uc774\ud130\uc758 \uc77c\uad00\uc131\uacfc \uad00\uacc4\uc5c6\uc774 \uae30\ub2e4\ub9ac\uc9c0 \uc54a\uace0 \ube68\ub9ac \ub370\uc774\ud130\ub97c \uc77d\uc5b4\uc624\uae30\ub97c \uc6d0\ud558\ub294 \uacbd\uc6b0\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n

\uc774 \ub54c \uc81c\uacf5\ub418\ub294 \uc635\uc158\uc774 NOLOCK\uc785\ub2c8\ub2e4.<\/p>\n\n

SQL \ucffc\ub9ac\ub97c \uc2e4\ud589\ud560 \ub54c WITH NOLOCK<\/span>\ub77c\ub294 \uc635\uc158\uc744 \uc8fc\uba74 \ub370\uc774\ud130\uc758 \uc77c\uad00\uc131\uacfc \uc0c1\uad00\uc5c6\uc774 \uae30\ub2e4\ub9ac\uc9c0 \uc54a\uace0 \ub370\uc774\ud130\ub97c \uc870\ud68c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n

<\/p>\n\n

\ucc38\uace0\ub85c WITH NOLOCK \uc635\uc158\uc740 \ud604\uc7ac \uc811\uc18d\ud55c \ucffc\ub9ac\uc5d0 \ub300\ud574\uc11c\ub9cc \uc801\uc6a9\ub418\ub294 \uc635\uc158\uc774\uace0 <\/p>\n\n

\ub9cc\uc57d \uc804\uccb4 \uc811\uc18d\uc5d0 \ub300\ud574 READ COMMITED\ub97c \ud574\uc81c\ud558\uace0 \uc2f6\uc73c\uba74 \uc544\ub798\uc640 \uac19\uc774 \uc2dc\uc2a4\ud15c \ucffc\ub9ac\ub97c \uc2e4\ud589\ud574\uc11c READ UNCOMMITED<\/span>\ub85c \ubc14\uafc0 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n

\nSET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED<\/code><\/pre>\n\n <\/p>\n","rating":"0.0","like_count":"1","mentioned_user_nos":"[]","is_secret":"N","is_deleted":"N","deleted":"","created":"2019-04-15 13:15:07","comment_html":"
DB\ub97c \ud1b5\ud574\uc11c \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\uac70\ub098(SELECT), \uc800\uc7a5\/\ubcc0\uacbd\/\uc0ad\uc81c(INSERT,UPDATE,DELETE)\ub97c \ud560 \uc218 \uc788\ub294\ub370<\/p>\n\n
\ud558\ub098\uc758 DB\uc5d0 \uc5ec\ub7ec \uc0ac\ub78c\ub4e4\uc774 \uc811\uc18d\ud574\uc11c \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\uac70\ub098 \ubcc0\uacbd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n
 <\/p>\n\n
\uadf8\ub7f0\ub370 \ub3d9\uc2dc\uc5d0 \uc5ec\ub7ec \uc0ac\ub78c\uc774 \ud558\ub098\uc758 DB\uc5d0 \uc811\uc18d\ud558\ub2e4\ubcf4\uba74 \ub3d9\uc2dc\uc131\uc758 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud569\ub2c8\ub2e4.<\/p>\n\n
\uc608\ub97c \ub4e4\uba74, \uc5b4\ub5a4 \uc811\uc18d\uc5d0 \uc758\ud574 \ub370\uc774\ud130\uac00 \ubcc0\uacbd\ub418\uace0 \uc788\ub294\ub370 \ubcc0\uacbd\ub418\uace0 \uc788\ub294 \ubc14\ub85c \uadf8 \uc9e7\uc740 \uc21c\uac04\uc5d0<\/p>\n\n
\ub204\uad70\uac00\uac00 \ub370\uc774\ud130\ub97c \uc77d\uc744 \ub54c \uc544\uc9c1 \ubcc0\uacbd\uc774 \uc644\ub8cc\ub418\uc9c0 \uc54a\uc740 \uc815\ud655\ud558\uc9c0 \uc54a\uc740 \ub370\uc774\ud130\ub97c \uc77d\uc5b4\uc628\ub2e4\ub4e0\uac00 \ud558\ub294 \ub4f1\uc758 \uacbd\uc6b0\uac00 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n
 <\/p>\n\n
\uc774\ub7f0 \ubb38\uc81c\ub97c \ubc29\uc9c0\ud558\uae30 \uc704\ud574 MS SQL\uc5d0\uc11c\ub294 \ud558\ub098\uc758 \uc811\uc18d\uc774 \ud2b9\uc815 \uc791\uc5c5\uc744 \ud558\ub294 \ub3d9\uc548 \ub2e4\ub978 \uc791\uc5c5\uc744 \ubabb\ud558\ub3c4\ub85d isolation<\/span>(\uc77c\uad00\uc131)\uc774 \uac78\ub9ac\ub3c4\ub85d \ub418\uc5b4\uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n
\uc989, \ud558\ub098\uc758 \uc811\uc18d\uc774 \ub370\uc774\ud130\ub97c \ubcc0\uacbd\ud558\ub294 \uc791\uc5c5\uc744 \uc644\uc804\ud788 \ub05d\ub0bc \ub54c\uae4c\uc9c0 \ub2e4\ub978 \uc811\uc18d\uc774 \ub370\uc774\ud130\ub97c \uc77d\uc744 \uc218 \uc5c6\ub3c4\ub85d \ud558\ub294 \uac83\uc774 \uae30\ubcf8 \uac12\uc778\ub370<\/p>\n\n
\uc774 \uc218\uc900\uc758 isolation\uc744 READ COMMITED<\/span>\ub77c\uace0 \ud569\ub2c8\ub2e4.<\/p>\n\n
\ub2e4\uc2dc \ub9d0\ud574, \ub370\uc774\ud130\uac00 COMMITED(\ubcc0\uacbd \uc791\uc5c5 \uc644\ub8cc)\ub41c \uacbd\uc6b0\uc5d0\ub9cc \uc870\ud68c\ub97c \ud560 \uc218 \uc788\ub3c4\ub85d \ud558\uace0<\/p>\n\n
\uadf8\ub807\uc9c0 \uc54a\uc73c\uba74 COMMITED\ub418\uae30 \uc804\uae4c\uc9c0\ub294 \uc811\uc18d\uc5d0 LOCK\uc744 \uac78\uc5b4\uc11c \uae30\ub2e4\ub9ac\uac8c \ub9cc\ub4ed\ub2c8\ub2e4.<\/p>\n\n
 <\/p>\n\n
\uadf8\ub7f0\ub370 \ub54c\ub85c\ub294 \ub370\uc774\ud130\uc758 \uc77c\uad00\uc131\uacfc \uad00\uacc4\uc5c6\uc774 \uae30\ub2e4\ub9ac\uc9c0 \uc54a\uace0 \ube68\ub9ac \ub370\uc774\ud130\ub97c \uc77d\uc5b4\uc624\uae30\ub97c \uc6d0\ud558\ub294 \uacbd\uc6b0\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n
\uc774 \ub54c \uc81c\uacf5\ub418\ub294 \uc635\uc158\uc774 NOLOCK\uc785\ub2c8\ub2e4.<\/p>\n\n
SQL \ucffc\ub9ac\ub97c \uc2e4\ud589\ud560 \ub54c WITH NOLOCK<\/span>\ub77c\ub294 \uc635\uc158\uc744 \uc8fc\uba74 \ub370\uc774\ud130\uc758 \uc77c\uad00\uc131\uacfc \uc0c1\uad00\uc5c6\uc774 \uae30\ub2e4\ub9ac\uc9c0 \uc54a\uace0 \ub370\uc774\ud130\ub97c \uc870\ud68c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n
 <\/p>\n\n
\ucc38\uace0\ub85c WITH NOLOCK \uc635\uc158\uc740 \ud604\uc7ac \uc811\uc18d\ud55c \ucffc\ub9ac\uc5d0 \ub300\ud574\uc11c\ub9cc \uc801\uc6a9\ub418\ub294 \uc635\uc158\uc774\uace0 <\/p>\n\n
\ub9cc\uc57d \uc804\uccb4 \uc811\uc18d\uc5d0 \ub300\ud574 READ COMMITED\ub97c \ud574\uc81c\ud558\uace0 \uc2f6\uc73c\uba74 \uc544\ub798\uc640 \uac19\uc774 \uc2dc\uc2a4\ud15c \ucffc\ub9ac\ub97c \uc2e4\ud589\ud574\uc11c READ UNCOMMITED<\/span>\ub85c \ubc14\uafc0 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n
\nSET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED<\/code><\/pre>\n\n <\/p>\n","summary":"DB\ub97c \ud1b5\ud574\uc11c \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\uac70\ub098(SELECT), \uc800\uc7a5\/\ubcc0\uacbd\/\uc0ad\uc81c(INSERT,UPDATE,DELETE)\ub97c \ud560 \uc218 \uc788\ub294\ub370\n\n\ud558\ub098\uc758 DB\uc5d0 \uc5ec\ub7ec \uc0ac\ub78c\ub4e4\uc774 \uc811\uc18d\ud574\uc11c \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\uac70\ub098 \ubcc0\uacbd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\n\n \n\n\uadf8\ub7f0\ub370 \ub3d9\uc2dc\uc5d0 \uc5ec\ub7ec \uc0ac\ub78c\uc774 \ud558\ub098\uc758 DB\uc5d0 \uc811\uc18d\ud558\ub2e4\ubcf4\uba74 \ub3d9\uc2dc\uc131\uc758 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud569\ub2c8\ub2e4.\n\n\uc608\ub97c \ub4e4\uba74, \uc5b4\ub5a4 \uc811\uc18d\uc5d0 \uc758\ud574 \ub370\uc774\ud130\uac00 \ubcc0\uacbd\ub418\uace0 \uc788\ub294\ub370 ..."}]

#데이터베이스

질문isolation 과 with nolock 관계