bcgov / bcgov/STRR

Backend - application_number, registration_number & username `ilike` pattern

Open
#1,394 0 comments 0 reactions 1 assignee Assigned to @kris-daxiom View on GitHub
STR
Dominant language
Python
Stars
2
Forks
22
Avg merge
2d 35m
Merged PRs (30d)
11

Description

Follow up to our earlier discussion:
Currently `application_number`, `registration_number` & `username` implement regular B-tree index and the `ilike` operations on these are `%term%` patterns.

With this pattern and index type, it would often do full table scans.
We can update the pattern to `term%` which will be very fast. But this would mean, let's say to filter on username in Test to enter `idiir\...`.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.