[PaaS] FixedAclJob returns all entries instead of limiting to the batch size
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.
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.