Can a historical database be partitioned on multiple levels – say, by date, then symbol?

No. Only one level of partitioning (by date, month, year or integer) is supported.

I’ve setup many views based on a single large table. How much of a performance penalty will I pay?

A view is syntactic sugar for a canned query. Unless the view is referenced, it does not expend computational resources.

See also: view, views, :: , .z.b and \b

I want to keep kdb rdb super fast and prevent users from introducing large latencies by using a timeout argument of 2 seconds. is this a good idea?

It is true that no single user query will block for more than the time specified in the -T command line argument. However, be sure to disable timeout via \T 0 prior to executing the end-of-day batch processing, or it will fail with a ‘stop error.


This work is licensed under a Creative Commons License.
The views and opinions expressed herein are those of the authors and do not necessarily reflect those of any other person or legal entity.
Kdb+ is the registered trademark of Kx Systems, Inc.