Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

...