I am attempting to do a Count points in polygon routine for a clean looking 'density' grid. I have around 800,000 points over a large polygon grid.
My workstation has 24 cores and 128gb RAM, and yet the process will often take twelve hours or longer to complete. A look at the processor affinity shows 4 CPUs out of the bunch being hit at any one time for a moment, punctuated by extended periods where nothing appears to happen, and the output filesize does not increase.
My data are in the same SpatiaLite db, with indexes built.
The output does eventually complete, and gives me what I expect. However, are there any tweaks or options I could explore in QGIS to improve this speed or distribute the processing across more CPUs?