title: How to improve frequent BigQuery reads?
body: <p>I'm using BigQuery for Java to do small reads on a table with about ~5GB of data. The queries I do follows the most standard SQL like <code>SELECT foo FROM my-table WHERE bar=$1</code> where the result will be at most 1 row. I need to do this at a high frequency and therefore performance is a big concern. How do I optimize for this?</p>
  <p>I thought about pulling the entire data set periodically since it's only 5GB, but then again 5GB sounds like a lot to be constantly keeping in memory.</p>
  <p>Running this query in BigQuery console shows something like <code>Query complete (0.6 sec elapsed, 4.2 GB processed)</code>. Fast for 4.2 GB but not fast enough. Again, I need to <strong>very</strong> frequently read from it but rarely (maybe once a day or week) write to it.</p>
  <p>Maybe tell the server to cache the processed data somehow?</p>