Autosuggestions: Index the uppercase requirement key

Fix versions

Priority

Description

In RY-962, we've noted it was too slow to search requirements per lower key.
We'll add a column "UPPERKEY" where we'll store the uppercase requirement key, for search.

Risks

  • It may take some space in the database to store both KEY and UPPERKEY (but it is worth it for indexing),

  • The two values may become unsynchronized if we program wrongly. Currently, both values are set using the same method, we need to keep it this way.

Activity

Show:
Resolved

Details

Assignee

Reporter

Requirement Yogi

Created February 7, 2022 at 4:54 PM
Updated February 24, 2022 at 1:34 PM
Resolved February 7, 2022 at 5:39 PM