Well, I “only” have 32k (simple) products on my magento but for 12 sites, around 15k activated per website, so around 180000 products to deal with, and there is no problem. Well, almost. I just reindexed the url, and:
time php /***/shell/indexer.php --reindex catalog_url
Catalog URL Rewrites index was rebuilt successfully
So more than 2 days to perform it -___-
But that’s it. It runs pretty well on a 4x 2.66+ GHz 8GB DDR3. Hopefully.