[ADMINCTR-389] Port to Master - Findbar iterates over all nodes in the pages/assets app on presenting the ui. Created: 26/Apr/23  Updated: 17/May/23  Resolved: 09/May/23

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

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

Issue Links:
Cloners
clones ADMINCTR-386 Findbar iterates over all nodes in th... Closed
Template:
Acceptance criteria:
Empty
Task DoR:
Empty
Documentation update required:
Yes
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:40 CET 2024 using Jira 9.4.2#940002-sha1:46d1a51de284217efdcb32434eab47a99af2938b.