Enumerations · 1 min read

MySqlBulkImportPseudoTableType

An enumeration that is being used to define the type of staging (pseudo) table to be created during the bulk-import operations.

This enum defines the type of staging (pseudo) table created during bulk-import operations. It applies only to RepoDb.MySql.BulkOperations (the MySql.Data-based driver).

It is used by the following bulk operations.

Enum Values

Name	Description
Auto	Chooses between `Physical` and `Memory` based on row count. This is the default.
Memory	A `TEMPORARY` table, private to each session. Safe for concurrent/multi-connection workloads.
Physical	An ordinary heap table, shared by every session. Only safe for sequential (non-concurrent) workloads against the same target table.

Every value currently resolves to Physical at runtime, including an explicit Memory and Auto’s row-count threshold. The TEMPORARY TABLE branch is fully implemented in the SQL builder, but the resolution step that picks between them (ResolvePseudoTableType) currently maps every input to Physical unconditionally, until that path is enabled and verified against a live server. See Operations (MySql) for details.

Usability

Pass the value to the pseudoTableType argument of the target operation.

using (var connection = new MySqlConnection(connectionString))
{
    var people = GetPeople(1000);
    var mergedRows = connection.BulkMerge(people,
        pseudoTableType: MySqlBulkImportPseudoTableType.Physical);
}