Were importing and regularly updating 40,000+ nodes and have had to use drush amongst other things to make it perform well. One thing that was disappointing was the massive performance hit from using pathauto, it increased the time it took to import & update by at least 1000%, which is a no go for us.

Did you find some other solution, we have a few ideas but I am curious if you found a good option?