Filtering in Grid backed by JCR uses wildcards for non string values (MGNLUI-7084)

[MGNLUI-7137] Do performance check Created: 04/May/22  Updated: 09/May/22  Resolved: 09/May/22

Status: Completed
Project: Magnolia UI
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Sub-task Priority: Neutral
Reporter: Alejandro Gomez Assignee: Adam Siska
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Template:
Date of First Response:
Sprint: Nucleus 9
Team: Nucleus

 Comments   
Comment by Adam Siska [ 09/May/22 ]

1000 nodes in 2 level structure, 10 % matching the query (filter on enum):
WITH wildcards
423 77 46 45 45 44 35 27 26 35 35 19 27 18 17 16 26 14 21 20
WITHOUT wildcards
163 30 28 22 18 18 14 15 13 13 11 10 12 14 15 14  9 13  8 14

conclusion: there is a significant performance gain

Generated at Mon Feb 12 09:43:28 CET 2024 using Jira 9.4.2#940002-sha1:46d1a51de284217efdcb32434eab47a99af2938b.