Table size

Community Support
1

Hi,

I am having trouble retrieving size of a splayed, partitioned table. -22! reports a tiny number, few hundred bytes. I assume it does so because
entire table is not memory. Related question. If I were to execute count very_large_table, does KDB have to fit whole table
into memory or does it scan one partition after another?

Thanks

2

Hi,

See the below link for a useful utility, which you can use to create a dictionary mapping each partition name to its row count.

http://code.kx.com/wiki/DotQ/DotQDotpn

Jason

3

Thank you, for others readers .Q.pv!flip .Q.pn

4

On Thursday, January 19, 2017 at 4:56:44 AM UTC-5, gekaprog wrote:

Hi,

I am having trouble retrieving size of a splayed, partitioned table. -22! reports a tiny number, few hundred bytes. I assume it does so because
entire table is not memory. Related question. If I were to execute count very_large_table, does KDB have to fit whole table
into memory or does it scan one partition after another?

Thanks