Category oracle

Bulk Collect speeds

Quick example [sourcecode language=”sql”] ——————————————————– — Quick test on insert rates Oracle DB ——————————————————– SET TIMING ON; SET ECHO ON; SET LINES 200; ——————————————————– — DDL for Table LOG_DATA ——————————————————– CREATE TABLE "LOG_DATA" ( "ID" NUMBER, "DATA1" VARCHAR2(255 ), "DATA2"…