On 31-Mar-08, at 6:57 AM, Evgeniy Strokin wrote:
I have two questions related to the subject:
1. If I have 100 fields in my document, all indexed. Will my queries
run slower if I store all 100 fields or just 10?
Depends on that total size of the stored fields. Really large stored
documents can result in more disk seeks to fetch the documents to
return.
2. If I have 100 fields in my documents, all stored. Will my queries
run slower if I index all 100 fields or just 10?
Not really.
Whether there is a practical difference depends strongly on the size
of your index, the heft of the machine you're using, and the
definition of "slower". There really isn't any fixed advice other
than "benchmark it under production-like conditions".
-Mike
