...

• Sequential IO is faster than random
• Maintenance of internal database data structures is expensive, it is better to rebuild them from scratch in bulks when data load is finished
• Acquiring of per-entry locks is expensive, so it is better to escalate lock to upper level (typically - table)
• Crash recovery of data being loaded is typically not needed

Oracle

Oracle offers "direct path load" [1] as the fastest method to populate data. Direct path load can be from both command line utility SQL*Loader to load existing files (resembling Ignite's COPY command), and with conventional SQL, such as {{INSERT}} and {{CREATE TABLE AS SELECT}} (CTAS).

[1] https://docs.oracle.com/cd/E11882_01/server.112/e22490/ldr_modes.htm#SUTIL009
[2] https://docs.oracle.com/en/database/oracle/oracle-database/18/admin/managing-tables.html#GUID-134D6EB6-219E-4820-AB54-8C60067A8F0F

PostgreSQL

TODO

MySQL and MariaDB

TODO

Proposed Changes

TODO

Tickets

...