Struct BatchConfig 

pub struct BatchConfig {
    pub batch_size: usize,
    pub max_payload_bytes: usize,
    pub multi_row_insert: bool,
    pub use_copy: bool,
    pub parallelism: usize,
}

Configuration for batch operations.

Fields

batch_size: usize

Number of rows per batch.

max_payload_bytes: usize

Maximum payload size in bytes.

multi_row_insert: bool

Whether to use multi-row INSERT syntax.

use_copy: bool

Whether to use COPY for bulk inserts (PostgreSQL).

parallelism: usize

Parallelism level for bulk operations.

Implementations

impl BatchConfig

pub const fn default_config() -> Self

Default batch configuration.

pub fn for_database(db_type: DatabaseType) -> Self

Create configuration optimized for the given database.

pub fn auto_tune( db_type: DatabaseType, avg_row_size: usize, total_rows: usize, ) -> Self

Auto-tune batch size based on row size and count.

This calculates an optimal batch size that:

• Stays within the max payload size
• Balances memory usage vs round-trip overhead
• Adapts to row size variations

Example

use prax_query::db_optimize::BatchConfig;
use prax_query::sql::DatabaseType;

// Auto-tune for 10,000 rows averaging 500 bytes each
let config = BatchConfig::auto_tune(
    DatabaseType::PostgreSQL,
    500,    // avg row size in bytes
    10_000, // total row count
);
println!("Optimal batch size: {}", config.batch_size);

pub fn batch_ranges(&self, total: usize) -> impl Iterator<Item = (usize, usize)>

Create an iterator that yields batch ranges.

Example

use prax_query::db_optimize::BatchConfig;

let config = BatchConfig::default_config();
let total = 2500;

for (start, end) in config.batch_ranges(total) {
    println!("Processing rows {} to {}", start, end);
}

pub fn batch_count(&self, total: usize) -> usize

Calculate the number of batches for a given total.

Trait Implementations

impl Clone for BatchConfig

fn clone(&self) -> BatchConfig

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for BatchConfig

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Default for BatchConfig

fn default() -> Self

Returns the “default value” for a type.

impl Copy for BatchConfig