Welcome to the Q&A Forum

Hi, I found the exact problem you are facing with a solution on this link http://magento.stackexchange.com/questions/17553/magento-core-url-rewrite-table-excessively-large There are patch codes available on this link, however do read this reply on this page Bugs in earlier (and possibly current) versions of Magento is one. Another is there's logic in this table that tries to track changes to the URL key value so that 301/302 rewrites are setup for old products. Because of this, and complicating things, truncating the table and regenerating may make existing URL rewrites go away, and this will have an unknown effect on your search engine listing (not necessity bad, just hard to predict). My general advice to clients who ask is Leave the giant growing table as is if you don't have a good handle on your URL/SEO situation Until the table size starts being a problem (generating site maps, for example). When that happens, get a handle on your URL/SEO situation. Once you have a handle on your URL/SEO situation, backup the table, then truncate the table and regenerate. Address any URL/SEO problems caused by the truncating. Automate step 3 Trying to fix this on the Magento code level is admirable, but you'll be swimming upstream. Sometimes it's better to accept that "That's just Magento being Magento", and to solve the problem with and external process. I hope this helps, if you have further questions, then post a response, I will be happy to answer. Regards, Vijay

You have 1300 products and about 1500 pages with 6 months. How about traffic of your site? How about your content? How about backlinks? Did you submit link to Google? Did you use data migration and change SEO URL? If everything is good, it cannot DA, PA equip zero.