Finally, inserting data into the table requires certain preprocessing
before data can be inserted. However, the insertion
of data row by row will incur a high amount of pre-processing
time before data are inserted. Therefore, techniques such as
batching can speed up the insertion process by orders of
magnitude as rows of records are kept as buffers before they
are inserted. This avoids the need to insert a large number
records row by row but instead keeps a buffer of records
before inserting in one single insert operation.