title: Lookup a field or Index for filter search?
body: <p>I fetch have a large collection (35k+ - list of products)</p>
  
  <pre><code>for each item_cache in products_cache
      list.Add(New Products With {
          .product_id = item_cache.id,
          .product_name = item_cache.name,
          .moreHere = item_cache.moreHere,
          .moreHere = item_cache.moreHere,
          .moreHere = item_cache.moreHere,
          .moreHere = item_cache.moreHere
          })
  next
  
  return list.Tolist
  </code></pre>
  
  <p>The params we currently have are all in strings (home.aspx?p_name='Shirts').</p>
  
  <p>After I have the list collection, is it better to search through string or search through index? </p>
  
  <pre><code>return list.where(function(c) c.product_name = 'Shirts')
  </code></pre>
  
  <p>Or should I retrieve first the index (PK) of the string</p>
  
  <pre><code>Dim p_id As Integer = dataGetIdOfProduct('Shirts')
  
  return list.where(function(c) c.product_id = p_id)
  </code></pre>