Everything working great with my system except one thing. The residential class of properties has over 35000 listings. Updating this class is much much slower than the other classes. The lease class has like 5000 and updates in about 30 minutes. The land class has around 17000 and updates in a few hours. For both classes processing 50 nodes is taking some number of seconds. I am updating using the UNLIMITED chunk option.
The residential class is taking over 6-10 minutes to process 50 nodes. Why would it take so much longer to process 50 nodes for the residential class? It is taking over 3 days to update this class. I don't see why it should be any different than the others. Any ideas on what the bottleneck could be?