in memory is much faster. Restrict dates, syms and fields as much as possible -- read as little as possible, e.g.  </p>

<xmp>select time,price from trade where date=2000.10.02,sym=`IBM
</xmp>
<p>is faster than</p>

<xmp>select from trade where date=2000.10.02,sym=`IBM / all fields
</xmp>
<p>Move as little data as possible -- calculate in the server, e.g. from java:</p>

<xmp>r=k("select size wavg price from trade where date=2000.10.02,sym=`IBM");
</xmp>
<p>is much faster than pulling the data and calculati