Skip to content

Change transact_block_operations in the store to doing bulk operations #2223

Closed
@lutter

Description

@lutter

When we apply changes for a block, we issue individual SQL queries for each entity. Instead, we should change these operations to do bulk updates, for example, to clamp all entities that need it in one query. Ideally, transacting operations for a block will only issue 2 queries per block and entity type, one to update the block range of updated/deleted entities, and one to insert new entity versions.

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions