Merge and update on a table with a composite primary key extremely slow.
Maintainers usually reply within 1 day
Nobody has claimed this yet.
Assessment
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Newbie friendliness
- 30/100
- Issue type
- Bug
- Clarity
- Needs clarification
- Activity status
- Stale
- Domain
- databases, performance
Research direction
The report concerns the 2.3.232 regression in MERGE and UPDATE statements on tables with composite primary keys, but names no source files or tests. Start by reproducing the reported slowdown and compare execution time with an IDENTITY primary key; done means restoring comparable performance for composite-key MERGE and UPDATE operations.
Written by the indexing model from the issue text.
Description
Merge and update on a table with a composite primary key extremely slow.
After upgrading to the latest version, 2.3.232 merge and update statements became up to 25 times slower on a table with a composite primary key.
Had to replace the composite key with an ID (IDENTITY) column as primary key to reduce the execution time for merge and only use one WHERE condition on ID for update.
- Dominant language
- Java
- Stars
- 4.6k
- Forks
- 1.3k
- Avg merge
- 1d 9h
- Merged PRs (30d)
- 27
Getting set up
This project ships no dev container, Dockerfile or contributing guide, so setting up is up to you: start from its README, and see our first-contribution guide for the general steps.
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from h2database/h2database
-
It's not necessary to copy the memory block in the readWrite() of org.h2.store.fs.mem.FileMemDataOpen
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
h2database/h2database#4435 ·
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 76/100
h2database/h2database#4354 · 1 comment ·
Maintainers usually reply within 1 day
-
Difficulty 4/5 3-5 days Newbie friendliness 55/100
h2database/h2database#4425 · 3 comments ·
Maintainers usually reply within 1 day
-
BUG: Parenthesized UNION term returns stale result when only its FETCH / OFFSET / ORDER BY parameter changesPossibly taken @kalayciburak claimed this 8 days ago. Open
Difficulty 3/5 1-2 days Newbie friendliness 76/100
h2database/h2database#4421 ·
Maintainers usually reply within 1 day
-
Difficulty 3/5 1-2 days Newbie friendliness 68/100
h2database/h2database#4408 ·
Maintainers usually reply within 1 day
All issues in h2database/h2database
Similar issues
-
Difficulty 2/5 1-3 hours Newbie friendliness 86/100
-
Make branch and label autocomplete matching locale-independentPossibly taken A pull request linked to this issue is open or already merged. Open
Difficulty 2/5 1-3 hours Newbie friendliness 83/100
jenkinsci/gitlab-plugin#1950 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 65/100
commons-app/apps-android-commons#6984 ·
Maintainers usually reply within 2 days
-
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
micronaut-projects/micronaut-core#13717 ·
Maintainers usually reply within 1 day