\u5ba2\u6237\u5728\u5927\u91cf\u52a0\u8f7d\u6570\u636e\u662f\u9047\u5230\u6027\u80fd\u95ee\u9898\uff0c\u68c0\u67e5\u540e\u53d1\u73b0\u5ba2\u6237\u91c7\u7528\u7684\u662f\u5355\u6761\u63d2\u5165\u5355\u6761\u63d0\u4ea4\u8fd9\u79cd\u6700\u7f13\u6162\u7684\u65b9\u5f0f\uff0c\u4e3a\u4e86\u7ed9\u5ba2\u6237\u8bf4\u660e\u4f18\u5316\u6548\u679c\uff0c\u73b0\u573a\u505a\u4e86\u51e0\u4e2a\u4ee3\u7801\u3002
\n\u6700\u7b80\u5355\u7684\u4f18\u5316\u65b9\u5f0f\u83ab\u8fc7\u4e8e\u51cf\u5c11COMMIT\u9891\u5ea6\uff0c\u800c\u6700\u4f18\u5316\u7684\u65b9\u5f0f\u662f\u91c7\u7528\u6279\u91cf\u63d2\u5165\u7684\u65b9\u5f0f\uff0c\u7b80\u5355\u7684\u6d4b\u8bd5\u4ee3\u7801\u5982\u4e0b\uff1a<\/p>\n
SQL> CREATE TABLE T_INSERT (ID NUMBER, NAME VARCHAR2(30));\r\nTable created.\r\nSQL> SET TIMING ON \r\nSQL> BEGIN\r\n2 FOR I IN 1..100000 LOOP\r\n3 INSERT INTO T_INSERT VALUES (I, 'A' || I);\r\n4 COMMIT;\r\n5 END LOOP;\r\n6 END;\r\n7 \/\r\nPL\/SQL procedure successfully completed.\r\nElapsed: 00:00:05.22\r\nSQL> BEGIN\r\n2 FOR I IN 1..100000 LOOP\r\n3 INSERT INTO T_INSERT VALUES (I, 'A' || I);\r\n4 COMMIT;\r\n5 END LOOP;\r\n6 END;\r\n7 \/\r\nPL\/SQL procedure successfully completed.\r\nElapsed: 00:00:05.51\r\nSQL> BEGIN\r\n2 FOR I IN 1..100000 LOOP\r\n3 INSERT INTO T_INSERT VALUES (I, 'A' || I);\r\n4 IF MOD(I, 1000) = 0 THEN\r\n5 COMMIT;\r\n6 END IF;\r\n7 END LOOP;\r\n8 COMMIT;\r\n9 END;\r\n10 \/\r\nPL\/SQL procedure successfully completed.\r\nElapsed: 00:00:04.01\r\nSQL> BEGIN\r\n2 FOR I IN 1..100000 LOOP\r\n3 INSERT INTO T_INSERT VALUES (I, 'A' || I);\r\n4 IF MOD(I, 1000) = 0 THEN\r\n5 COMMIT;\r\n6 END IF;\r\n7 END LOOP;\r\n8 COMMIT;\r\n9 END;\r\n10 \/\r\nPL\/SQL procedure successfully completed.\r\nElapsed: 00:00:02.64\r\nSQL> DECLARE\r\n2 TYPE T_NUM IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;\r\n3 TYPE T_VAR IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;\r\n4 V_NUM T_NUM;\r\n5 V_VAR T_VAR;\r\n6 BEGIN\r\n7 FOR I IN 1..100000 LOOP\r\n8 V_NUM(I) := I;\r\n9 V_VAR(I) := 'A' || I;\r\n10 END LOOP;\r\n11 FORALL I IN 1..100000 \r\n12 INSERT INTO T_INSERT VALUES (V_NUM(I), V_VAR(I));\r\n13 COMMIT;\r\n14 END;\r\n15 \/\r\nPL\/SQL procedure successfully completed.\r\nElapsed: 00:00:00.37\r\nSQL> DECLARE\r\n2 TYPE T_NUM IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;\r\n3 TYPE T_VAR IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;\r\n4 V_NUM T_NUM;\r\n5 V_VAR T_VAR;\r\n6 BEGIN\r\n7 FOR I IN 1..100000 LOOP\r\n8 V_NUM(I) := I;\r\n9 V_VAR(I) := 'A' || I;\r\n10 END LOOP;\r\n11 FORALL I IN 1..100000 \r\n12 INSERT INTO T_INSERT VALUES (V_NUM(I), V_VAR(I));\r\n13 COMMIT;\r\n14 END;\r\n15 \/\r\nPL\/SQL procedure successfully completed.\r\nElapsed: 00:00:00.50<\/pre>\n\u8fd9\u4e2a\u4f8b\u5b50\u660e\u786e\u8bf4\u660e\u4e86\u5355\u6761\u63d0\u4ea4\u3001\u6279\u91cf\u63d0\u4ea4\u4ee5\u53ca\u6570\u503c\u63d2\u5165\u7684\u6027\u80fd\u5dee\u5f02\uff0c\u5f88\u591a\u65f6\u5019\u53ea\u662f\u53e3\u5934\u4e0a\u7684\u63cf\u8ff0\uff0c\u5ba2\u6237\u4e0d\u4f1a\u6709\u592a\u6df1\u7684\u5370\u8c61\uff0c\u800c\u5982\u679c\u901a\u8fc7\u8fd9\u79cd\u4f8b\u5b50\u6765\u5c55\u793a\u6027\u80fd\u7684\u5dee\u522b\uff0c\u7ed3\u679c\u4e00\u76ee\u4e86\u7136\uff0c\u6bd4\u518d\u591a\u7684\u63cf\u8ff0\u90fd\u7ba1\u7528\u5f97\u591a\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5ba2\u6237\u5728\u5927\u91cf\u52a0\u8f7d\u6570\u636e\u662f\u9047\u5230\u6027\u80fd\u95ee\u9898\uff0c\u68c0\u67e5\u540e\u53d1\u73b0\u5ba2\u6237\u91c7\u7528\u7684\u662f\u5355\u6761\u63d2\u5165\u5355\u6761\u63d0\u4ea4\u8fd9\u79cd\u6700\u7f13\u6162\u7684\u65b9\u5f0f\uff0c\u4e3a\u4e86\u7ed9\u5ba2\u6237\u8bf4\u660e\u4f18\u5316\u6548\u679c\uff0c\u73b0\u573a\u505a\u4e86\u51e0\u4e2a\u4ee3\u7801\u3002 \u6700\u7b80\u5355\u7684\u4f18\u5316\u65b9\u5f0f\u83ab\u8fc7\u4e8e\u51cf\u5c11COMMIT\u9891\u5ea6\uff0c\u800c\u6700\u4f18\u5316\u7684\u65b9\u5f0f\u662f\u91c7\u7528\u6279\u91cf\u63d2\u5165\u7684\u65b9\u5f0f\uff0c\u7b80\u5355\u7684\u6d4b\u8bd5\u4ee3\u7801\u5982\u4e0b\uff1a SQL> CREATE TABLE T_INSERT (ID NUMBER, NAME VARCHAR2(30)); Table created. SQL> SET TIMING ON SQL> BEGIN 2 FOR I IN 1..100000 LOOP 3 INSERT INTO T_INSERT VALUES (I, ‘A’ || I); 4 COMMIT; 5 END LOOP; 6 END; … Continue reading