...
Most industrial vendors rely on the following techniquesassumptions:
- Favor sequential IO over 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
...