summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorÉtienne Loks <etienne.loks@iggdrasil.net>2023-11-28 15:30:34 +0100
committerÉtienne Loks <etienne.loks@iggdrasil.net>2023-11-28 15:34:00 +0100
commit308e0fb9afd3747d7f7822058582ea701a71aaf7 (patch)
tree41a22781ca6f7e4dfe1ce06b0aa9e2c7d24adb43
parenta5d3afd375e0232f51a9525f54a455b8b2529090 (diff)
downloadIshtar-308e0fb9afd3747d7f7822058582ea701a71aaf7.tar.bz2
Ishtar-308e0fb9afd3747d7f7822058582ea701a71aaf7.zip
🐛 Document table: fix performance issue on sort (refs #5667)
-rw-r--r--changelog/en/changelog_2022-06-15.md1
-rw-r--r--changelog/fr/changelog_2023-01-25.md1
-rw-r--r--ishtar_common/models.py2
3 files changed, 4 insertions, 0 deletions
diff --git a/changelog/en/changelog_2022-06-15.md b/changelog/en/changelog_2022-06-15.md
index df6e0630b..92c87144e 100644
--- a/changelog/en/changelog_2022-06-15.md
+++ b/changelog/en/changelog_2022-06-15.md
@@ -6,6 +6,7 @@ v4.0.67 - 2023-11-28
- Instance Profile:
- fix migration: provide default for complete id and cached label (#5674)
- fix "default center" field (#5675)
+- Document table: fix performance issue on sort (#5667)
v4.0.66 - 2023-11-22
--------------------
diff --git a/changelog/fr/changelog_2023-01-25.md b/changelog/fr/changelog_2023-01-25.md
index 4b822e556..5295d75d5 100644
--- a/changelog/fr/changelog_2023-01-25.md
+++ b/changelog/fr/changelog_2023-01-25.md
@@ -6,6 +6,7 @@ v4.0.67 - 2023-11-28
- Profile d'instance :
- correction de migration de base de données : valeur par défaut pour l'identifiant complet et le libellé mise en cache (#5674)
- correction du champ "centre par défaut" (#5675)
+- Table documents : correction d'un problème de performance lors du tri (#5667)
v4.0.66 - 2023-11-22
--------------------
diff --git a/ishtar_common/models.py b/ishtar_common/models.py
index a1fd5e714..27388658c 100644
--- a/ishtar_common/models.py
+++ b/ishtar_common/models.py
@@ -3927,6 +3927,7 @@ class Document(
"authors__cached_label",
"associated_url",
]
+ NEW_QUERY_ENGINE = True
COL_LINK = ["associated_url"]
BASE_SEARCH_VECTORS = [
SearchVectorConfig("title"),
@@ -3980,6 +3981,7 @@ class Document(
"authors__person__pk": "authors__person__pk",
"container_id": "container_id",
"publisher__pk": "publisher__pk",
+ "source_type__label": "source_type__label",
}
# alternative names of fields for searches