Skip to content

搜索区分大小写根据配置项单独建立索引 #5889

New issue
New issue
Closed
Closed
搜索区分大小写根据配置项单独建立索引#5889
Assignees
88250
Labels
Enhancement
Milestone
 
2.2.0
@88250

Description

@88250
88250
opened on Sep 16, 2022
Member
  • 表 blocks_fts 大小写敏感
  • 表 blocks_fts_case_insensitive 大小写不敏感

这两张表同时写入比较占用资源，将改进为默认大小写不敏感，仅写入 blocks_fts_case_insensitive 表，在 设置 - 搜索 - 区分大小写 中开启后再同时写入 blocks_fts，开启或关闭均会自动重建索引。

Activity

88250
added
Enhancement
on Sep 16, 2022
88250
added this to the 2.2.0 milestone on Sep 16, 2022
88250
self-assigned this
on Sep 16, 2022
88250
added a commit that references this issue on Sep 16, 2022

🎨 搜索区分大小写根据配置项单独建立索引 Fix #5889

0db807c
88250
closed this as completedon Sep 16, 2022
leolee9086
added a commit that references this issue on Oct 4, 2022

🎨 搜索区分大小写根据配置项单独建立索引 Fix siyuan-note#5889

3599742
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

Enhancement

Type

No type

Projects

No projects

Milestone

Relationships

None yet

    Development

    No branches or pull requests

      Participants

      @88250

      Issue actions
        搜索区分大小写根据配置项单独建立索引 · Issue #5889 · siyuan-note/siyuan