[ENG-5076] oaipmh slowness

CenterForOpenScience / SHARE

SHARE is building a free, open, data set about research and scholarly activities across their life cycle.

http://share-research.readthedocs.io/en/latest/index.html

Apache License 2.0

100 stars 58 forks source link

[ENG-5076] oaipmh slowness #819

Closed aaxelb closed 3 months ago

aaxelb commented 3 months ago

speed up the oai-pmh database query

add indexes on LatestIndexcardRdf.modified and Indexcard.deleted
make a few small subqueries separately, to reduce query planning complexity

ENG-5076

coveralls commented 3 months ago

coverage: 89.616% (+0.01%) from 89.606% when pulling d909fc670de12a28245bd3b9d99622d2400a6ae3 on aaxelb:fix/oaipmh-slowness into 581301600e05d028c8f364eda9cc26aee0ea29ca on CenterForOpenScience:develop.