subcategory solution

[eluser]Twisted1919[/eluser]
[quote author="cahva" date="1271544529"]
Save the full seo path(call it seo, slug whatever) to databse. For example for the product1, save "shoes/blue-shoes/summer-shoes/product1" as the seo url. With this saved, you can do search from the database easily. I did the mistake NOT to save the path in the first place and had to "travel" the segments one by one, which ofcourse caused overhead.
[/quote]

Nice one , makes sense to save it to database .

L.E: But if you have 1000 products and you change a category name , doesn't this mean that you need to update all the url's in database ?