Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Start moving forced-id inline to ResourceTable #4260

Merged
merged 19 commits into from Nov 16, 2022

Conversation

michaelabuckley
Copy link
Contributor

The join to HFJ_FORCED_ID is expensive. We are starting to move it into HFJ_RESOURCE. To allow zero-downtime upgrades, we are doing this in three steps:

  1. Add the column and start filling it
  2. Add the index, fill any missing values, and start querying the new field.
  3. Drop the old table.

This PR implements step 1.

@codecov
Copy link

codecov bot commented Nov 8, 2022

Codecov Report

Base: 81.00% // Head: 81.16% // Increases project coverage by +0.15% 🎉

Coverage data is based on head (90cfd5b) compared to base (02944ba).
Patch has no changes to coverable lines.

Additional details and impacted files
@@             Coverage Diff              @@
##             master    #4260      +/-   ##
============================================
+ Coverage     81.00%   81.16%   +0.15%     
- Complexity    23466    23498      +32     
============================================
  Files          1446     1439       -7     
  Lines         86175    86107      -68     
  Branches      11798    11745      -53     
============================================
+ Hits          69809    69887      +78     
+ Misses        11087    10989      -98     
+ Partials       5279     5231      -48     
Impacted Files Coverage Δ
...ir/jpa/provider/r4/BaseResourceProviderR4Test.java 0.00% <0.00%> (-95.32%) ⬇️
...uhn/fhir/jpa/term/config/TermCodeSystemConfig.java 75.00% <0.00%> (-25.00%) ⬇️
...bscription/channel/impl/LinkedBlockingChannel.java 72.72% <0.00%> (-17.28%) ⬇️
ca/uhn/fhir/jpa/test/config/TestJPAConfig.java 87.50% <0.00%> (-12.50%) ⬇️
ca/uhn/fhir/jpa/provider/BaseJpaProvider.java 52.54% <0.00%> (-7.81%) ⬇️
ca/uhn/fhir/util/ThreadPoolUtil.java 93.33% <0.00%> (-6.67%) ⬇️
...terceptor/SubscriptionSubmitInterceptorLoader.java 94.44% <0.00%> (-5.56%) ⬇️
ca/uhn/fhir/jpa/model/entity/ForcedId.java 95.23% <0.00%> (-4.77%) ⬇️
ca/uhn/fhir/jpa/util/MemoryCacheService.java 84.61% <0.00%> (-3.69%) ⬇️
...searchparam/extractor/SearchParamExtractorR4B.java 59.52% <0.00%> (-2.70%) ⬇️
... and 122 more

Help us with your feedback. Take ten seconds to tell us how you rate us. Have a feature suggestion? Share it here.

☔ View full report at Codecov.
📢 Do you have feedback about the report comment? Let us know in this issue.

@michaelabuckley michaelabuckley enabled auto-merge (squash) November 9, 2022 19:11
@michaelabuckley michaelabuckley self-assigned this Nov 9, 2022
michaelabuckley and others added 2 commits November 9, 2022 18:56
…_3_0/4260-inline-forcedid.yaml

Co-authored-by: James Agnew <jamesagnew@gmail.com>
…_3_0/4260-inline-forcedid.yaml

Co-authored-by: James Agnew <jamesagnew@gmail.com>
…d-id-inline

* commit '9a45576793a279ba1722853ab7c847745595b22e':
  Cache service loaders (#4196)
  Post release HAPI FHIR cleanup (#4266)
  Bump log4j-to-slf4j from 2.17.1 to 2.19.0 (#4265)
  ValueSet cleanup (#4227)
  Rel 6 2 mergeback (#4257)
  Issue 4180 process slows down to a crawl while loading uscore ig (#4201)
Ensure we flush, and check resource version.
@michaelabuckley michaelabuckley merged commit 6c4283e into master Nov 16, 2022
@michaelabuckley michaelabuckley deleted the mb-forced-id-inline branch November 16, 2022 18:38
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

None yet

4 participants