Skip to content

replace ilike to lower like #1203

@zdyj3170101136

Description

@zdyj3170101136

for now, lucene search in hyperdx is ilike:

Body ilike '%version%'

it is slow.

add index:

INDEX bf (s, lower(s)) TYPE ngrambf_v1(3, 512, 2, 0) GRANULARITY 1

search sql below could use index to enhancement query speed:

Body like '%1.2.0%'
lower(Body) like lower('%1.2.0%')

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions