[ADMINCTR-386] Findbar iterates over all nodes in the pages/assets app on presenting the ui Created: 14/Mar/22  Updated: 15/May/23  Resolved: 28/Apr/23

Status: Closed
Project: Admincentral
Component/s: None
Affects Version/s: 6.2.28
Fix Version/s: 6.2.29

Type: Bug Priority: High
Reporter: Rico Jansen Assignee: Miguel Martinez
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Cloners
is cloned by ADMINCTR-389 Port to Master - Findbar iterates ove... Closed
Problem/Incident
is caused by ADMINCTR-226 Make Findbar search starting with an ... Closed
relation
is related to MGNLPER-190 Find and document opportunities to im... Open
Template:
Acceptance criteria:
Empty
Release notes required:
Yes
Documentation update required:
Yes
Date of First Response:
Epic Link: [JCR] Search Performance issues
Story Points: 2
Team: AuthorX
Work Started:
Approved:
Yes

 Description   

I am investigating performance issues on our migration to Magnolia 6.

When I first deployed it on our test server when I logged in de ui would be very slow and not show the results from the pages and dam app in the first screen.

Trying to open the pages app would take a very long time as well (probably related to the initial query on the website still running). Investigation showed that JcrSearchResultSupplier would query for all nodes in the websites repository using an empty wildcard like ('%%'). On our website repository with more then 100.000 pages this does not perform. It does this as well on the dam repository which has even more nodes than that. Those queries use a lot of memory as Jackrabbit traverses both indexes fully, which causes a lot of GC load.

As a workaround I created a modified JcrSearchResultSupplier to no longer generate those empty wildcard queries and this improved things quite a bit, the queries at least return in less then 10 seconds. However in our case this will not be sufficient as this is still too slow.

Measure and record the times before the change and after the change in this ticket using the big data environment.


Generated at Sun Feb 11 23:06:38 CET 2024 using Jira 9.4.2#940002-sha1:46d1a51de284217efdcb32434eab47a99af2938b.