Append to a file without loading the entire file

Community Support
1

I’m new to KDB ( sorry if this question is dumb). I’m creating the following table

dsPricing:([id:int$(); date:date$()] open:float$();close:float$();high:float$();low:float$();volume:`int$())

q)dsPricing:([id:int$(); date:date$()] open:float$();close:float$();high:float$();low:float$();volume:`int$())

q)`dsPricing insert(123;2003.03.23;1.0;3.0;4.0;2.0;1000)

q)`dsPricing insert(123;2003.03.24;1.0;3.0;4.0;2.0;2000)

q)save `:dsPricing

Let’s say after saving I exit. After starting q, I like to add another pricing item in there without loading the entire file because the file could be large

q)`dsPricing insert(123;2003.03.25;1.0;3.0;4.0;2.0;1500)

I’ve been looking at .Q.dpft  but I can’t really figure it out. Also this table/file doesn’t need to be partitioned.

Thanks