This section explains how to speed up data change statements: 本节介绍如何加速数据更改语句:INSERT
, UPDATE
, and DELETE
. INSERT
、UPDATE
和DELETE
。Traditional OLTP applications and modern web applications typically do many small data change operations, where concurrency is vital. 传统OLTP应用程序和现代web应用程序通常会执行许多小型数据更改操作,其中并发性至关重要。Data analysis and reporting applications typically run data change operations that affect many rows at once, where the main considerations is the I/O to write large amounts of data and keep indexes up-to-date. 数据分析和报告应用程序通常运行同时影响多行的数据更改操作,其中主要考虑的是写入大量数据并保持索引最新的I/O。For inserting and updating large volumes of data (known in the industry as ETL, for “extract-transform-load”), sometimes you use other SQL statements or external commands, that mimic the effects of 为了插入和更新大量数据(在业界称为ETL,用于“提取-转换-加载”),有时您会使用其他SQL语句或外部命令,模拟INSERT
, UPDATE
, and DELETE
statements.INSERT
、UPDATE
和DELETE
语句的效果。