Data Writing

There are a few options to write data to DolphinDB server using the C++ API. This section explains the differences between these options and their optimal use cases.

The following table lists differences of write options.

Write Option Description
MultithreadedTableWriter
  • multi-threaded, asynchronous writing
  • write data by row
  • built-in data buffer queue
tableInsert / insert into
  • synchronous writing
  • easy and fast to call
PartitionedTableAppender
  • synchronous writing
  • append with table
  • concurrent writes by partition
AutoFitTableAppender
  • automatic data type conversion before writing
  • append with table
  • single-threaded, synchronous writing
AutoFitTableUpsert
  • automatic data type conversion before writing
  • upsert with table
  • single-threaded, synchronous writing
BatchTableWriter (Deprecated)
  • real-time data drop, data write by rows
  • single-threaded, synchronous writing