diff options
| author | Hazelnoot <acomputerdog@gmail.com> | 2025-02-14 20:16:39 -0500 |
|---|---|---|
| committer | Hazelnoot <acomputerdog@gmail.com> | 2025-02-14 20:16:39 -0500 |
| commit | 493000290b830eda62a10f372a9ccc24e1e24d72 (patch) | |
| tree | 89b7843a80eb598884588164bbad43bd4ada53bd | |
| parent | Merge branch 'develop' into merge/2024-02-03 (diff) | |
| download | sharkey-493000290b830eda62a10f372a9ccc24e1e24d72.tar.gz sharkey-493000290b830eda62a10f372a9ccc24e1e24d72.tar.bz2 sharkey-493000290b830eda62a10f372a9ccc24e1e24d72.zip | |
fix performance of SQL LIKE note search
| -rw-r--r-- | packages/backend/src/core/SearchService.ts | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/packages/backend/src/core/SearchService.ts b/packages/backend/src/core/SearchService.ts index 5794d27d4a..d16f9eb6bd 100644 --- a/packages/backend/src/core/SearchService.ts +++ b/packages/backend/src/core/SearchService.ts @@ -281,7 +281,7 @@ export class SearchService { if (this.config.fulltextSearch?.provider === 'sqlPgroonga') { query.andWhere('note.text &@~ :q', { q }); } else { - query.andWhere('LOWER(note.text) LIKE :q', { q: `%${ sqlLikeEscape(q.toLowerCase()) }%` }); + query.andWhere('note.text ILIKE :q', { q: `%${ sqlLikeEscape(q) }%` }); } if (opts.host) { |