title: Is it a good approach to use internal data structure as memory database?
body: <p>I'm working on a very small scale program mostly working on using word initials to search for full strings and extra information attached to it, including in-program CRUD operations. Since there are only ~10k strings to be searched, I would prefer to use in-memory approach to quicken searches (since most of the queries is <code>SELECT</code>).</p>
  
  <p>Is it a good approach to simply use things like <code>List&lt;myobject&gt; data</code> and do something like this: <code>data.Where((s =&gt; s.text.Substring(0,3) == expected));</code>? Are there anything I can do regarding database optimization (like indexing) when I use this method?</p>