I'm attempting to perform a 'Join Attribute by Location (Summary)' between two polygon layers where I calculate the sum of a given field in the join layer using the 'Intersect' predicate. The process however seems extremely slow and it actually seems to be slowing down with time to the point of it being unusable.
The input layer has a feature count of 1,907,160 and the join layer has a feature count of 6,042,342. A sample visualization is given below (input layer are the brown rectangles):
Both layers have spatial indexes created. Wondering if there's a way to speed up the process. I've also added the current log file below: