In our current system ,we have 3 fields for location, city, state, and country. People in our system search for one of those 3 strings. So a user can search for "San Francisco" or "California". In solr I store those 3 fields as strings and when a search happens I search with an OR statement across those 3 fields.
Is there a more efficient way to store this data storage wise and/or speed wise? We don't currently plan to use any spacial features like "3 miles near SF".