KX Community

Mike_Thompson

If I set for compression: .z.zd:(17;2;6)and then create a splayed, partitioned table. and then subsequent attempt to access this splayed/partitioned/compressed table then q.exe crashes. "select from t" is sufficient to trigger the crash provided "t" ...

Mike_Thompson

If I create a splayed, partitioned table having previously set for compression: .z.zd:(17;2;6)and then subsequent attempt to access this table I get an error message: Can't protect memoryAnd q.exe quits. On Windows 7. KDB+ 3.1 2013.06.14 Copyright (C...

Mike_Thompson

I've been reading KDB+ for Mortals, Chapter 1 which covers building databases, and I have a question ...If I partition my database on, say, date, can I then choose to NOT splay the tables (within each partition)? Just to be clear ...Let's say I creat...

Mike_Thompson

I'm puzzled by the behavior of "wj". Here's my experiement:q) t:([] time: 10:00:03 10:00:04 10:00:05)q) t1:([] time: 10:00:01 10:00:03 10:00:03 10:00:04 10:00:08; b: 1 10100 1000 10000)q) w: ( t.time; t.time )q) wj[w;`time;t;(t1;(::;`b))] / here's wh...

Mike_Thompson

Is there a way of doing this more efficiently (in a "wj")?q) count each group 1 2 3 4 5 1 1 21| 32| 23| 14| 15| 1This does all the work associated with the "group" operator, but thenit throws a lot of that away when all we want is a "count". Seemswas...

Mike_Thompson

Hi Charles, I'm seeing the same issue again. The combination of Windows and compression is causing q.exe to crash. Cheers,Mike

Mike_Thompson

Yes, I'd be interested in links to either qpy or pyQ. Also, do theywork with the KDB 32bit version under windows? I'd imagine they needa DLL and the win32 version doesn't supply a DLL I don't think (justan exe)On Mar 10, 2:29�pm, Puns wrote:> Hi Ansh...

Mike_Thompson

I've staring at "wj" for a while, trying to figure out how it did it'swork. Based on those observations I've written up own variation whichdoes what I want. For what it is worth, I include the key bit of codebelow:/-----------------------------------...

Mike_Thompson

>> q){[m] select from tp where start<=t,end>=t } each mSorry, meant:{select from tp where start<=x,end>=x } each m

Mike_Thompson

On Dec 3, 11:30�pm, Mike Thompson wrote:> I�m wondering if there's a more efficient way of achieving> something ...>> I have a table defining intervals of time, defined by a start and end> time �(ie. time pairs at minute resolution):> tp: ([] start: ...

KX Community

User Statistics

User Activity

Problems with Compression On Windows

Can't protect memory

Splaying / Partitioning

Puzzled Over The Behavior of "wj"

Faster than { count each group x }

Re: Can't protect memory

Re: Accessing Python inside q

Re: Puzzled Over The Behavior of "wj"

Re: Improving Performance

Re: Improving Performance