Optimize SQL returned from `dolt_patch()`
Open
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.