Class BatchQueryOptimizer

Batch query optimizer

Index

Constructors

Methods

setDefaultOptions optimizeBatchInsert optimizeBatchUpdate optimizeBatchDelete

Constructors

constructor

new BatchQueryOptimizer(
dialect: Dialect,
defaultOptions?: Partial<BatchOptions>,
): BatchQueryOptimizer
Parameters
- dialect: Dialect
- OptionaldefaultOptions: Partial<BatchOptions>
Returns BatchQueryOptimizer
- Defined in query-optimizers/batch-optimizer.ts:80

Methods

setDefaultOptions

setDefaultOptions(options: Partial<BatchOptions>): void
Set default options for batch operations
Parameters
- options: Partial<BatchOptions>
Returns void
- Defined in query-optimizers/batch-optimizer.ts:95

optimizeBatchInsert

optimizeBatchInsert(
    tableName: string,
    records: Record<string, any>[],
    options?: Partial<BatchOptions>,
): Promise<BatchResult<any>>
Optimize batch insert by combining multiple INSERT statements
Parameters
- tableName: string
  Name of the table to insert into
- records: Record<string, any>[]
  Array of records to insert
- Optionaloptions: Partial<BatchOptions>
  Batch options
Returns Promise<BatchResult<any>>
- Defined in query-optimizers/batch-optimizer.ts:105

optimizeBatchUpdate

optimizeBatchUpdate(
    tableName: string,
    records: Record<string, any>[],
    identifierColumn?: string,
    options?: Partial<BatchOptions>,
): Promise<BatchResult<any>>
Optimize batch update
Parameters
- tableName: string
  Name of the table to update
- records: Record<string, any>[]
  Records to update (must have primary key or unique identifier)
- identifierColumn: string = 'id'
  Column to use for identifying records
- Optionaloptions: Partial<BatchOptions>
  Batch options
Returns Promise<BatchResult<any>>
- Defined in query-optimizers/batch-optimizer.ts:258

optimizeBatchDelete

optimizeBatchDelete(
    tableName: string,
    identifiers: any[],
    identifierColumn?: string,
    options?: Partial<BatchOptions>,
): Promise<BatchResult<any>>
Optimize batch delete
Parameters
- tableName: string
  Name of the table to delete from
- identifiers: any[]
  Array of identifiers for records to delete
- identifierColumn: string = 'id'
  Column to use for identifying records
- Optionaloptions: Partial<BatchOptions>
  Batch options
Returns Promise<BatchResult<any>>
- Defined in query-optimizers/batch-optimizer.ts:413