Well, you're kind of stuck unfortunately. It's pretty much required that you'll
have to reindex when you add new fields if you want existing documents to
have that field.
I don't think there's any good way to use the DB to sort Solr results that would
be performant.
About using Solr as your data
As I'm using solr more and more, I'm finding that I need to do searches and
then order by new criteria. So I am constantly add new fields into solr
and then reindexing everything.
I want to know if adding in all this data into solr is the normal way to
deal with sorting. I'm finding that I have