[Taginfo-dev] [taginfo/taginfo] 133fd8: Move creation of full text search around to speed ...

Jochen Topf noreply at github.com
Sun Oct 11 07:42:53 UTC 2020


  Branch: refs/heads/master
  Home:   https://github.com/taginfo/taginfo
  Commit: 133fd81a212ad935d40ebbc9a4753db37e720a01
      https://github.com/taginfo/taginfo/commit/133fd81a212ad935d40ebbc9a4753db37e720a01
  Author: Jochen Topf <jochen at topf.org>
  Date:   2020-10-11 (Sun, 11 Oct 2020)

  Changed paths:
    M sources/db/add_extra_indexes.sql
    A sources/db/add_ftsearch.sql
    M sources/db/pre.sql
    M sources/update_all.sh

  Log Message:
  -----------
  Move creation of full text search around to speed it up

Turns out creating the ftsearch virtual table later and using more cache
memory speeds up the creation of the index massively.





More information about the Taginfo-dev mailing list