Linked Column Size

Community Support
1

I have a linked column on a splayed table.  The disk size of the column seems peculiarly large.  Its about the size of all the other columns combined.  Does this seem right?  Or do I have something wrong here?

2

Hi Roni. The size of the linked column should be the rowcount*8.

3

Thanks Charles,

My trade table for example has 23 572 273 rows and my `mas table has 12 976 rows.

I am adding the linked column using

addcol[:/hdb;trade;mas;{mas!mas.sym?get()sv x, sym}];

and my `mas column on that table is 92, 080kb.

does this look right to you? The math doesn’t seem to add up

4

ahah. Linked columns are still underpinned by 32bit int, just like enums.

so that should be rowCount*4 (approx, as there’s the header and byte alignment to add).

q)(4*23572273)%1024
92079.19

So, yes, looks ok.

Btw, you can load the linked column explicitly to inspect it

e.g.
q)get:t1link t1!2 1 2 0i

5

Awesome, Thanks so much!