Add generic fuzzy matching logic to the database layer
Bug #1881865 reported by
haixin
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Shared File Systems Service (Manila) |
Fix Released
|
Medium
|
haixin |
Bug Description
share list, share snap list, Fuzzy query by name or description is supported, but the current implementation is first get all the shares, then In the API layer, the for loop is used to achieve fuzzy matching, if the num of shares is big,
It will seriously affect the speed of fuzzy matching.Therefore, we should let the database do the matching to speed up the query.
i also noticed that in share snap list api, Paging query parameters limit and offset same problem with fuzzy queries,we also need to move those to database layer to deal with it.
Changed in manila: | |
assignee: | nobody → haixin (haixin77) |
Changed in manila: | |
importance: | Undecided → Medium |
milestone: | none → victoria-2 |
Changed in manila: | |
milestone: | victoria-2 → victoria-3 |
Changed in manila: | |
assignee: | haixin (haixin77) → Goutham Pacha Ravi (gouthamr) |
Changed in manila: | |
milestone: | victoria-3 → victoria-rc1 |
Changed in manila: | |
assignee: | Goutham Pacha Ravi (gouthamr) → haixin (haixin77) |
Changed in manila: | |
milestone: | victoria-rc1 → wallaby-1 |
Changed in manila: | |
milestone: | wallaby-1 → wallaby-2 |
Changed in manila: | |
milestone: | wallaby-2 → wallaby-3 |
tags: | added: wallaby-rc-bugsquash |
Changed in manila: | |
milestone: | wallaby-3 → wallaby-rc1 |
Changed in manila: | |
milestone: | wallaby-rc1 → xena-1 |
tags: |
added: wallaby-backport-potential removed: wallaby-rc-bugsquash |
Changed in manila: | |
milestone: | xena-1 → xena-2 |
To post a comment you must log in.
Fix proposed to branch: master /review. opendev. org/734041
Review: https:/