core_url_rewrite is built in the wrong way:
- why it contains records for not visible products ( all simple associated to the configurable for example )
- why it contains records for every storeview even if the
url_path) for a product/category is the same for every
I actually have 394415 records on this table ( my store has 28120 products and 7
storeviews ), if I could solve the above 2 point I think the table would be 10 times smaller.
Anybody worked on this before ?