[PaaS] FixedAclJob returns all entries instead of limiting to the batch size

Description

We noticed that the query that retrieves the nodes to be processed by the FixedAclJob returns all the nodes with the aspect "sys:pendingFixAcl" every time. The customer has over 4.6 million nodes with this aspect, so it takes 5 minutes to run the query and return all 4.6 million nodes.

Since the job is running in batches, can we not just return the first X nodes to fulfill the batch size? that would speed up the process considerably.

Environment

Alfresco PaaS

Testcase ID

None

Activity

Show:
Miguel Rodriguez
2 days ago

I did run the query limiting to 100 entries and still painfully slow, down from 5 minutes for 4.5 million entries to 3 minutes 36 secs for 100 entries. We save 1.5 minutes on each query but still slow.

Assignee

Unassigned

Reporter

Miguel Rodriguez

Labels

None

Escalated By

None

Security Issue

None

ACT Numbers

PaaS customers

Premier Customer

Yes

Code Branch

None

Build Location

None

Patch Attached

None

Dependent Version/s

None

Cloud or Enterprise

None

Prioritization Score

None

Bug Priority

Category 2

Delivery Team

None

Fix versions

Affects versions