Reasonable number of indices


(Marty) #1

This may be oversimplified, but we have about 50M docs and a query
rate of 75 queries/second. What is a seemingly reasonable number of
indexes to have? Right now I have 6 -- timestamp, primary
description, secondary description, score0, score1, score2.
Score[012] are intended to bias searches.

Is this too many?


(system) #2