I remember there was a bug in Magento 1.7 and EE 1.12 which generated URL writes each time a category was saved. We noticed this when clients started seeing millions of URL rewrites. There was a patch for EE1.12 which also worked for 1.7. Do you know if this bug was fixed in 1.8? The reason I ask is I have a client who started at 1.3 and is now on 1.8 and their urls are at 200,000 (6700 SKU's 300 categories)
The URLS have grown by 20,000 in the past week along.
Best Answer
The patch for EE 1.12 work to resolve the re-write problems
SUPEE-389_EE_1.12.0.2_v1.patch
Here is the code from Github #!/bin/bash # Patch apllying tool template # v0.1.2 # (c) Copyright 2013. Magento Inc. # # DO NOT CHANGE ANY LINE IN THIS FILE.