dolthub / dolthub/dolt

Optimize SQL returned from `dolt_patch()`

Open
#6,710 2 comments 0 reactions 0 assignees View on GitHub
customer issue enhancement sql version control
Dominant language
Go
Stars
24.4k
Forks
873
Avg merge
1d 5h
Merged PRs (30d)
108

Description

Currently `dolt_patch()` is a very literal interpretation of the diff. For every row added theer is an insert statement. This optimizes for readability/parse-ability but can be slow to actually apply.

We should add an option to compress the SQL do that it is fast to actually apply. One simple thing to do would be to group many insert statements into one single statement with many values. I'm sure there are other optimizations beyond that to explore.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.