From 8746beb2bbc61ed676e9540f896a5474cd60eaf8 Mon Sep 17 00:00:00 2001
From: Pjotr Prins
Date: Mon, 29 May 2023 07:41:32 -0500
Subject: Reduced issue priority. Task mostly done.

---
 issues/slow-sql-query-for-xapian-indexing.gmi | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'issues')

diff --git a/issues/slow-sql-query-for-xapian-indexing.gmi b/issues/slow-sql-query-for-xapian-indexing.gmi
index 3e5030c..882e1c0 100644
--- a/issues/slow-sql-query-for-xapian-indexing.gmi
+++ b/issues/slow-sql-query-for-xapian-indexing.gmi
@@ -1,9 +1,11 @@
 # Slow query
 
+Essentially two tables were utf8 (= utf8mb3). The others are utf8mb4. When comparing text fields mariadb can't optimize because it is translating utf8mb3 for every comparison. Changing the table and indices to utf8mb4 or latin1 (on production) fixed it.
+
 # Tags
 
 * assigned: pjotrp, aruni
-* priority: high
+* priority: medium
 * status: in progress
 * keywords: slow query
 
-- 
cgit v1.2.3