Skip to content

Use to postgres built-in fulltext search #439

Open
@tobiasdiez

Description

@tobiasdiez

Currently, we get all documents matching the search expression and then filtering them by hand. To increase performance, one should instead use postgres fulltext search. Prisma is now supporting this: https://www.prisma.io/docs/concepts/components/prisma-client/full-text-search
But there are still a few limitations (e.g. the index needs to be handled externally). Thus, let's wait a bit until that feature is fully implemented.
Should also sort by relevance https://prisma.io/docs/concepts/components/prisma-client/filtering-and-sorting#sort-by-relevance-postgresql

Depends on:

Metadata

Metadata

Assignees

No one assigned

    Labels

    p2: has workaroundBug for which an acceptable workaraound existstatus: blockedBlocked by an issue / missing feature of a dependency, or by another issuetype: enhancementImproving upon an existing feature

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions