Linked Column Size

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?

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

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

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

Awesome, Thanks so much!