Optimize ListElementLinks SQL queries by using prefetch and more explicit queries

Fix #626 (closed)

Codecov Report

Merging #1187 (d39825e3) into master (2dd45ed3) will increase coverage by 0.00%. The diff coverage is 100.00%.

@@           Coverage Diff           @@
##           master    #1187   +/-   ##
=======================================
  Coverage   88.18%   88.18%           
=======================================
  Files         253      253           
  Lines       16837    16840    +3     
=======================================
+ Hits        14848    14851    +3     
  Misses       1989     1989           

Impacted Files	Coverage Δ
arkindex/documents/api/entities.py	96.94% <100.00%> (+0.02%)
arkindex/documents/tests/test_entities_api.py	100.00% <100.00%> (ø)

---

Continue to review full report at Codecov.

Legend - Click here to learn more Δ = absolute <relative> (impact), ø = not affected, ? = missing data Powered by Codecov. Last update 2dd45ed...d39825e. Read the comment docs.

added 1 commit

• f46177cb - Add numQueries in unit tests

Compare with previous version

added 1 commit

• be011e67 - Help postgres to join entities

Compare with previous version

changed title from Optimize a bit ListElementLinks SQL queries by using prefetch to Optimize ListElementLinks SQL queries by using prefetch and more explicit queries

added 1 commit

• 0378ec0a - Fix typo

Compare with previous version

added 1 commit

• dc29e073 - Support cross references

Compare with previous version

requested review from @erwanrouchet

added 1 commit

• dbc2c1ff - Add assertExactQueries

Compare with previous version

resolved all threads

added 1 commit

• d39825e3 - Use .sql extension

Compare with previous version

approved this merge request

enabled an automatic merge when the pipeline for d39825e3 succeeds

merged

mentioned in commit 148adffc