docvalues with reindexing does not seem viable option for me as of
now...regarding second question on Xmx4G so i tried
various options Xmx8G, Xmx10G, Xmx12G all not worked except Xmx14G which
not seem practical for production with 16gb ram.
While searching i came across :
https://issues.apache.org
Hi Naresh
1) For 'sort by' fields, have you considered using DocValue=true for in
schema definition.
If you are changing schema definition, you would need redo full reindex
after backing up & deleting current index from dataDir.
Also note that, adding docValue=true would increase size of index.
Cluster details :
Solr Version : solr-4.10.4
No of nodes : 2 each 16 GB RAM
Node of shards : 2
Replication : 1
Each node memory parameter : -Xms2g, -Xmx4g
Collection details :
No of docs in my collection : 12.31 million
Indexed field per document : 2
Unique key field : tids
Stored filed per doc