Concurrent Multi-Insert Examples
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
To perform a trickle load into SingleStore, you can run concurrent processes that each load data in batches using the INSERT
command to insert up to several thousand rows in each statement.
For bulk loading into SingleStore, you can use the LOAD DATA
command or pipelines.LOAD DATA
is preferable for a small number of files that are not extremely large, loaded in an initial step before working with the data.
The following examples demonstrate how to perform concurrent multi-inserts with different tools/languages.
In this section
Last modified: March 14, 2023