diff options
| author | Pjotr Prins | 2023-05-29 07:41:32 -0500 |
|---|---|---|
| committer | Pjotr Prins | 2023-06-03 08:42:45 -0500 |
| commit | 8746beb2bbc61ed676e9540f896a5474cd60eaf8 (patch) | |
| tree | 8c5be5bdc9b47cf3853bce0819d462e1e1ee91d2 /issues/slow-sql-query-for-xapian-indexing.gmi | |
| parent | edb4668735704b01b2f974066e6d0515fa9738af (diff) | |
| download | gn-gemtext-8746beb2bbc61ed676e9540f896a5474cd60eaf8.tar.gz | |
Reduced issue priority. Task mostly done.
Diffstat (limited to 'issues/slow-sql-query-for-xapian-indexing.gmi')
| -rw-r--r-- | issues/slow-sql-query-for-xapian-indexing.gmi | 4 |
1 files changed, 3 insertions, 1 deletions
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 |