Is it possible to only store mapped products in the database?
I've just checked and we have around 500,000 products in the database, but probably show around 100 max on the frontend.
Maybe there are no performance issues with lots of rows, but I'd be happier with something more streamlined. Sometimes it's difficult to remove some categories from merchant feeds, for fear of not including a relevant product.
Thanks for any advice.