We are on Magento Version 22.214.171.124 and have been using Magento for a few years now. When we moved our site to the live site from the development site, we deleted all the development products but looks like the URL's created in the development site in the URL re-write table did not get deleted and are in the live site's table.
Over a period of time, this table as you all know has grown and now as 1.5 million records in it.
In our live site, I see that the system generated product ID (under Catalog --> Manage Products) starts at 2800. I assume that 2800 products were added during development and testing.
Using the SQL query below - shows that there are 500,000 records
SELECT * FROM
product_id <> 'NULL' AND
product_id < 2800 AND
product_id > 0;
My question is, is it safe to go ahead and delete these 500,000 records from the URL re-write table as these URL's are of no use since there are no associated products related to the URL. Will there be any SEO impact or any other issues that you foresee?
At least it will solve part of the problem for us.
Your advice and suggestions would be very helpful.