v0.4.1

[svdC1]

A query performance patch, no API or database changes

Fixed

• Form-Search Performance → Searching entries and proper names by a
  written or reading form previously compiled to correlated EXISTS
  subqueries that scanned every row (743k for names). The predicates are
  rewritten as a non-correlated id IN (... UNION ...) subquery that runs on
  the existing text indexes. kotobase.Kotobase.names drops from
  ~1.4s to ~2ms (~780x), kotobase.Kotobase.lookup from ~310ms to ~17ms, and
  kotobase.Kotobase.words_with_kanji from ~460ms to ~50ms.
  Result sets are unchanged and already-downloaded databases don't need a rebuild

---

This discussion was created from the release v0.4.1.