[MGNLUI-7755] Ability to improve JCR filtering performance by using STARTSWITH instead of CONTAINS operator Created: 19/Jan/23 Updated: 14/Feb/23 Resolved: 14/Feb/23 |
|
| Status: | Closed |
| Project: | Magnolia UI |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 6.3, 6.2.29 |
| Type: | Improvement | Priority: | Neutral |
| Reporter: | Rico Jansen | Assignee: | Sang Ngo Huu |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Σ Remaining Estimate: | Not Specified | Remaining Estimate: | Not Specified |
| Σ Time Spent: | 2d 2.5h | Time Spent: | 6.5h |
| Σ Original Estimate: | Not Specified | Original Estimate: | Not Specified |
| Issue Links: |
|
||||||||||||||||||||||||||||||
| Sub-Tasks: |
|
||||||||||||||||||||||||||||||
| Template: | |||||||||||||||||||||||||||||||
| Acceptance criteria: |
Empty
|
||||||||||||||||||||||||||||||
| Task DoD: |
[X]*
Doc/release notes changes? Comment present?
[X]*
Downstream builds green?
[X]*
Solution information and context easily available?
[X]*
Tests
[X]*
FixVersion filled and not yet released
[ ] 
Architecture Decision Record (ADR)
|
||||||||||||||||||||||||||||||
| Documentation update required: |
Yes
|
||||||||||||||||||||||||||||||
| Date of First Response: | |||||||||||||||||||||||||||||||
| Epic Link: | [JCR] Search Performance issues | ||||||||||||||||||||||||||||||
| Sprint: | Nucleus 29 | ||||||||||||||||||||||||||||||
| Story Points: | 3 | ||||||||||||||||||||||||||||||
| Team: | |||||||||||||||||||||||||||||||
| Work Started: | |||||||||||||||||||||||||||||||
| Description |
| Comments |
| Comment by Antonín Juran [ 19/Jan/23 ] |
DiscoveryIf we use LIKE with wildcard as postfix only, we'll limit the searching only to words starting with value from the filter. We could implement configuration of the wildcards. |