I'm storing a relational database as an index in solr, and wondering how to store the categories, or facets of my database?
Currently it works like this in mysql:
Category1 (ID:3) -> Category2 (ID:53) -> Product
I'm wondering would it be more efficient to store the ID, or store the actual text of the Category1 name in the Solr index?
When SOLR gives me back the facets I would have a list of IDs instead of text, so I could easily work out from my mysql store which Category related to which ID and build a navigation menu that way?
My feeling is that it is better to use IDs because these might be quicker in some way (storing less information), but I'm not sure, how do other people do it?