How is the q data cache?

Question

I tried to measure the data access time for the db created. He took ~ 1 s in one day. For aggregation, I executed the following code. I use kdb studio and ~ 1MM is being traded every day.

\t ans: raze {select from trade where date=x, sym=`ABC} each 20#dtl

dtl is an entire list of dates. I closed the server and started it again, and surprisingly it took 1 second. Since this was contrary to what I observed above, I ran this

\t ans: raze {select from trade where date=x, sym=`ABC} each 20#20_dtl

and now it took ~ 21 seconds. My question is: if I close the kdb server, is it possible q to cache some of the previous results?

Answer 1

KDB + . , , . , ( Unix- , root-). , KDB + . ( ... a la.Q.fu)

, , - 20 # dtl , date = x . , " x". - , -s .

Answer 2

, , , . Kdb + .