title: Fastest way to query repeatedly big table
body: <p>I have a table with 50 million records, but a compact structure (id, int1, int1, int2, int3). All relevant indexes are implemented. </p>
  
  <p>I need to query it about 50 times for each user interaction. This is taking about 5 seconds, using regular prepared queries against the db server. All the queries are simple selects.</p>
  
  <p>My question is: what can I do to speed up this, even spending significantly more memory? The Locate method for queries is not flexible enough and using filters directly into the query is slow. </p>
  
  <p>The main query I am running is </p>
  
  <pre><code>select knowledge_id, knowledge_family_id, tag_level, tag_order, 
    total_title_direct_words, total_title_parenthesis_words from knowledge_tags 
    where dictionary_word_id = XX order by tag_level, tag_order
  </code></pre>
  
  <p>Can anyone suggest a strategy? Would TVirtualTable increase speed?</p>