Use a prefetch for zones

Related to #701 (closed): This divides by half the time spent on ListCorpusElements when top_level is False.

See https://notes.vpn/k56It1gMQHWPvW14xu9wGg# for a benchmark on all corpora that shows the enhancements.

marked this merge request as draft

changed the description

changed the description

After discussion, let's try the following:

• remove corpus in order
• replace type__slug by type_id
• support type as UUID (maybe another MR)
• remove join on type

added 9 commits

• c5c65835...cabba7ae - 7 commits from branch master
• a1962ea0 - Use a prefetch for zones
• 0cf579f4 - Update query counts

Compare with previous version

marked this merge request as ready

changed the description

requested review from @babadie

I suggest still merging this as all the other changes will be done in other MRs and this brings an immediate enhancement on most ListCorpusElements and ListElementChildren queries.

merged

mentioned in commit e3bf8746