Developer Tools
Questions related to KX Developer Tooling
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

=?UTF-8?Q?How_to_calculate_the_rolling_co?=

Hi All I have a table t.q)tsym minute ri rm--------------------------------IBM 09:30:00 0.10 0.05IBM 09:31:00 0.05 0.03IBM 09:32:00 0.11 0.05IBM 09:33:00 0.13 0.02IBM 09:34:00 0.11 0.04 How to calculate the rolling covariance(cov1) and mobile covaria...

How to fill the gap of x - minute bars

Hi All, I calculate x-minute or x-second bars found some bars is lack. select last price,sum size by sym,3 xbar time.second from trade where date=last date example:3-second bars sym time price size -------------------------------------------- AAPL 09...

Production memory usage

Given the following 2 scenarios:1) A real time inmemory tick database generally not queried to frequently 2) A database of mostly static tables to which users can place unconstrained querieswhat kind of max memory consumption does kx recommend for pr...

abcfoots by New Contributor
  • 427 Views
  • 1 replies
  • 0 kudos

Optimizating csv import

The following program is parsing csv into in-memory table at about 22 MB/sec. I have repeated the benchmark a few times. The data is in the OS disk cache. The program is 1 core CPU-bound. My CPU is i5-3230M @ 2.60 GHz on a laptop. How can I make it f...

LamHinYan by New Contributor
  • 1884 Views
  • 12 replies
  • 0 kudos

. (dot) Does Not Work with mod?

Hi,I'm facing a strange error with mod and . (dot) operators. Please see the session log below:===============SESSION=======================D:\DEV>qKDB+ 3.2 2015.03.05 Copyright (C) 1993-2015 Kx Systemsw32/ 4()core 4095MB Think flying-thinkpad 192.16...

Flying by New Contributor III
  • 602 Views
  • 3 replies
  • 0 kudos