title: Restrict Magento incrementing numeric at the end of the URL after re-indexing
body: <p>I have Multi website,Multi store Magento with many of the products with duplicate url_key's. For duplicate url_key every re-indexing operations Magento unnecessarily keeps adding new url rewrite data by incrementing numeric at the end of the url and defines these new url rewrite rule of type 'custom'. My core_url_rewrite table in mysql is already grown beyond 2GB in one month only then imagine what could be table size after one year. 
  I need to restrict Magento incrementing numeric at the end of the URL somehow programmatically. I went through this discussion <a href="http://www.magentocommerce.com/boards/viewthread/416476/" rel="nofollow">http://www.magentocommerce.com/boards/viewthread/416476/</a> but <em>markf</em> with few others do not find <em>snowcountry</em>'s fix stable. Can you help me here with best solution? I will welcome entirely different approach as well.</p>