{"id":487,"date":"2025-07-16T12:40:06","date_gmt":"2025-07-16T03:40:06","guid":{"rendered":"https:\/\/sejiwon.com\/?p=487"},"modified":"2025-07-16T12:42:19","modified_gmt":"2025-07-16T03:42:19","slug":"%ed%8c%8c%ed%8b%b0%ec%85%94%eb%8b%9d%ec%9d%b4-%eb%90%98%ec%96%b4%ec%9e%88%eb%8a%94-%ed%85%8c%ec%9d%b4%eb%b8%94%ec%97%90-%ec%a3%bc%eb%a1%9c-insert%eb%a7%8c-%eb%b0%9c%ec%83%9d%ed%95%98%eb%8a%94","status":"publish","type":"post","link":"https:\/\/sejiwon.com\/?p=487","title":{"rendered":"\ud30c\ud2f0\uc154\ub2dd\uc774 \ub418\uc5b4\uc788\ub294 \ud14c\uc774\ube14\uc5d0 \uc8fc\ub85c insert\ub9cc \ubc1c\uc0dd\ud558\ub294 \ud14c\uc774\ube14\uc744 \ucc98\uc74c\ubd80\ud130 \uc555\ucd95\ud558\ub294 \uacbd\uc6b0\uc640 \ubcf4\uad00\uc804\uc5d0 \uc555\ucd95\ud558\ub294 \uacbd\uc6b0 \uc5b4\ub5a4 \uacbd\uc6b0\uac00 \ub354 \uc720\ub9ac\ud55c\uac00?"},"content":{"rendered":"\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u2705 \uc694\uc810 \uba3c\uc800:<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>\uad6c\ubd84<\/th><th><strong>\ucd08\uae30\ubd80\ud130 \uc555\ucd95<\/strong><\/th><th><strong>\ubcf4\uad00 \uc804 \uc555\ucd95<\/strong><\/th><\/tr><\/thead><tbody><tr><td>\u2705 \uc800\uc7a5\uacf5\uac04 \uc808\uc57d<\/td><td>\ube60\ub984 (\uc989\uc2dc)<\/td><td>\ub290\ub9bc (\ub098\uc911\uc5d0)<\/td><\/tr><tr><td>\u2705 CPU \uc0ac\uc6a9\ub7c9<\/td><td>\uc99d\uac00<\/td><td>\uc99d\uac00 (\ud55c \ubc88\uc5d0)<\/td><\/tr><tr><td>\u2705 INSERT \uc131\ub2a5<\/td><td><strong>\ub290\ub824\uc9d0 (\ud2b9\ud788 Page \uc555\ucd95)<\/strong><\/td><td><strong>\ube60\ub984<\/strong><\/td><\/tr><tr><td>\u2705 \uad00\ub9ac \ubcf5\uc7a1\ub3c4<\/td><td>\ub2e8\uc21c<\/td><td>\uc57d\uac04 \ubcf5\uc7a1<\/td><\/tr><tr><td>\u2705 \uc2e4\ubb34 \uc801\ud569\ub3c4 (\uc4f0\uae30 \uc704\uc8fc \ud14c\uc774\ube14)<\/td><td>\u274c \uc801\ud569\ud558\uc9c0 \uc54a\uc74c<\/td><td>\u2705 \ub354 \uc720\ub9ac\ud568<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83e\udde0 \uc0c1\uc138 \ubd84\uc11d:<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udccc 1. \ucc98\uc74c\ubd80\ud130 \uc555\ucd95 (\ucd08\uae30 \uc555\ucd95)<\/h3>\n\n\n\n<ul>\n<li><strong>INSERT \uc2dc\ub9c8\ub2e4 \uc555\ucd95 \uc791\uc5c5\uc774 \ud568\uaed8 \ubc1c\uc0dd<\/strong> \u2192 \ud2b9\ud788 <code>PAGE<\/code> \uc555\ucd95\uc740 CPU \uc790\uc6d0\uc744 \ub9ce\uc774 \uc0ac\uc6a9<\/li>\n\n\n\n<li>\ub370\uc774\ud130\uac00 <strong>\uacc4\uc18d \uc720\uc785\ub418\ub294 \ub3d9\uc548 \uc131\ub2a5 \uc800\ud558 \uac00\ub2a5\uc131<\/strong><\/li>\n\n\n\n<li><code>ROW<\/code> \uc555\ucd95\uc740 \ube44\uad50\uc801 \uc131\ub2a5 \uc601\ud5a5\uc774 \uc801\uc9c0\ub9cc, \uc555\ucd95\ub960\ub3c4 \ub0ae\uc74c<\/li>\n\n\n\n<li><strong>\uc4f0\uae30 \uc131\ub2a5\uc774 \uc911\uc694\ud55c OLTP\/\uc2e4\uc2dc\uac04 \uc218\uc9d1 \ud14c\uc774\ube14\uc5d0 \ubd80\uc801\ud569<\/strong><\/li>\n<\/ul>\n\n\n\n<p>\u2705 <strong>\uc5b8\uc81c \uace0\ub824\ud558\ub098?<\/strong><\/p>\n\n\n\n<ul>\n<li>INSERT \ube48\ub3c4\uac00 \ub0ae\uac70\ub098,<\/li>\n\n\n\n<li>\uc800\uc7a5 \uacf5\uac04 \uc808\uc57d\uc774 \ucd5c\uc6b0\uc120,<\/li>\n\n\n\n<li>\uc4f0\uae30 \uc131\ub2a5\ubcf4\ub2e4 \ube44\uc6a9 \uc808\uac10\uc774 \ub354 \uc911\uc694\ud55c \uacbd\uc6b0<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udccc 2. \ubcf4\uad00 \uc804\uc5d0 \uc555\ucd95 (\ub098\uc911 \uc555\ucd95)<\/h3>\n\n\n\n<ul>\n<li>\uc2e4\uc2dc\uac04\uc73c\ub85c\ub294 \uc555\ucd95\uc744 \ud558\uc9c0 \uc54a\uace0, \uc77c\uc815 \uae30\uac04 \ud6c4 <strong>\ubcf4\uad00 \ud30c\ud2f0\uc158\ub9cc \uc555\ucd95<\/strong><\/li>\n\n\n\n<li>\uc608: 1\uac1c\uc6d4\uce58 \ub370\uc774\ud130\ub97c \ub9e4\uc77c INSERT \u2192 \uc9c0\ub09c\ub2ec \ud30c\ud2f0\uc158\uc744 <code>PAGE<\/code> \uc555\ucd95<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>ALTER TABLE YourTableName \nREBUILD PARTITION = N \nWITH (DATA_COMPRESSION = PAGE);\n<\/code><\/pre>\n\n\n\n<ul>\n<li>INSERT\/UPDATE \uc131\ub2a5\uc5d0 \uc601\ud5a5 \uc5c6\uc774 \uc6b4\uc601 \uac00\ub2a5<\/li>\n\n\n\n<li><strong>\ud30c\ud2f0\uc158 \ub2e8\uc704\ub85c \uc555\ucd95\uc774 \uac00\ub2a5<\/strong>\ud558\ubbc0\ub85c \ud6a8\uc728\uc801\uc774\uace0 \uad00\ub9ac \uc6a9\uc774<\/li>\n\n\n\n<li>\ub514\uc2a4\ud06c IO \uac10\uc18c, \ubc31\uc5c5 \uc18d\ub3c4 \uac1c\uc120, \uacf5\uac04 \uc808\uc57d<\/li>\n<\/ul>\n\n\n\n<p>\u2705 <strong>\uc5b8\uc81c \uc801\ud569\ud558\ub098?<\/strong><\/p>\n\n\n\n<ul>\n<li>\ud30c\ud2f0\uc154\ub2dd\uc774 \uc798 \ub418\uc5b4 \uc788\uace0,<\/li>\n\n\n\n<li>\uc77c\uc815 \uae30\uac04 \ud6c4 \ub370\uc774\ud130 \ubcc0\uacbd\uc774 \uc5c6\ub294 \uacbd\uc6b0 (\ubcf4\uad00 \uc804\uc6a9),<\/li>\n\n\n\n<li>INSERT \uc131\ub2a5\uc774 \uc911\uc694\ud55c \uacbd\uc6b0<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83d\udee0 \uc2e4\ubb34 \ud301:<\/h2>\n\n\n\n<ol>\n<li><strong>\ud30c\ud2f0\uc158 \uc2a4\uc704\uce6d\uacfc \uc555\ucd95\uc744 \ubcd1\ud589<\/strong>\n<ul>\n<li>\uc0c8 \ub370\uc774\ud130\ub294 \uc555\ucd95 \uc5c6\uc774 <code>\uc2a4\ud14c\uc774\uc9d5 \ud14c\uc774\ube14<\/code>\uc5d0 INSERT<\/li>\n\n\n\n<li>\uc77c\uc815 \uae30\uac04 \ud6c4 \ud30c\ud2f0\uc158 \uc2a4\uc704\uce6d + \uc555\ucd95 \uc218\ud589<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\uc790\ub3d9\ud654 \uc2a4\ud06c\ub9bd\ud2b8 \ud65c\uc6a9<\/strong>\n<ul>\n<li>\ub9e4\uc6d4 \ub9d0\ub9c8\ub2e4 <code>\uc9c0\ub09c\ub2ec \ud30c\ud2f0\uc158<\/code>\uc744 \uc555\ucd95\ud558\ub294 \uc791\uc5c5 \uc608\uc57d<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83e\uddfe \uacb0\ub860<\/h2>\n\n\n\n<ul>\n<li><strong>INSERT \uc911\uc2ec \ud14c\uc774\ube14<\/strong>\uc740 <strong>\ucd08\uae30\ubd80\ud130 \uc555\ucd95\ud558\ub294 \uac83\uc740 \ube44\ud6a8\uc728\uc801<\/strong><\/li>\n\n\n\n<li><strong>\ud30c\ud2f0\uc158 \ub2e8\uc704 \ubcf4\uad00 \uc804 \uc555\ucd95<\/strong>\uc774 \ud6e8\uc52c \ud6a8\uc728\uc801\uc774\uace0 \uc131\ub2a5\uc5d0 \uc548\uc804\ud568<\/li>\n\n\n\n<li>\ud2b9\ud788 <code>PAGE \uc555\ucd95<\/code>\uc740 <strong>\uc4f0\uae30 \ubd80\ud558 \uc904\uc778 \ud6c4 \uc801\uc6a9<\/strong>\ud558\ub294 \uac83\uc774 \uc2e4\ubb34\uc801\uc73c\ub85c \uc815\uc11d<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u2705 \uc694\uc810 \uba3c\uc800: \uad6c\ubd84 \ucd08\uae30\ubd80\ud130 \uc555\ucd95 \ubcf4\uad00 \uc804 \uc555\ucd95 \u2705 \uc800\uc7a5\uacf5\uac04 \uc808\uc57d \ube60\ub984 (\uc989\uc2dc) \ub290\ub9bc (\ub098\uc911\uc5d0) \u2705 CPU \uc0ac\uc6a9\ub7c9 \uc99d\uac00 \uc99d\uac00 (\ud55c \ubc88\uc5d0) \u2705 INSERT \uc131\ub2a5 \ub290\ub824\uc9d0 (\ud2b9\ud788 Page \uc555\ucd95) \ube60\ub984 \u2705 \uad00\ub9ac \ubcf5\uc7a1\ub3c4 \ub2e8\uc21c \uc57d\uac04 \ubcf5\uc7a1 \u2705 \uc2e4\ubb34 \uc801\ud569\ub3c4 (\uc4f0\uae30 \uc704\uc8fc \ud14c\uc774\ube14) \u274c \uc801\ud569\ud558\uc9c0 \uc54a\uc74c \u2705 \ub354 \uc720\ub9ac\ud568 \ud83e\udde0 \uc0c1\uc138 \ubd84\uc11d: \ud83d\udccc 1. \ucc98\uc74c\ubd80\ud130\u2026 <span class=\"read-more\"><a href=\"https:\/\/sejiwon.com\/?p=487\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[11],"tags":[],"_links":{"self":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/487"}],"collection":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=487"}],"version-history":[{"count":2,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/487\/revisions"}],"predecessor-version":[{"id":491,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/487\/revisions\/491"}],"wp:attachment":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=487"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=487"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=487"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}