title: Any way to make Mongo filtering dynamic records faster?
body: <h3>Scenario</h3>
  
  <p>I have Mongo collection <code>Items</code> that have dynamic item objects in it. Currently I have over 3 million records. I'm using C# with MongoSharp but I don't think it has anything to do with my problem.</p>
  
  <p>Here is an example <code>Item</code> (<strong>it has a lot more fields than just 3</strong>):</p>
  
  <pre><code>{
    _id : "1234567890",
    Code : 888596937,
    RefNumber : "GHTZKL",
    ...
  }
  </code></pre>
  
  <p>AFAIK there is no point in using TextSearch since it's not really words, just some codes so it won't give me anything beneficial. I also cannot index them all since then I will have to index every single field.</p>
  
  <h3>Problem</h3>
  
  <p>Right now when I filter data it takes about 1-3 seconds (on ssd). Is there any way I can make it filter my items faster or it is as fast as I can get?</p>