Question on columnstore and the in-memory table

(Ported from memsql-public-chat Slack channel)

mukul-ivp [11:55 AM]
does update on columnstore happen on disk or the in-mem table ?

seth [1:06 PM]
@mukul-ivp, columnstore is ideal for batch loads. singleton operations are best suited for in-memory rowstore tables. Did you try the default table type in MemSQL (which is in-memory rowstore)?

mukul-ivp [20 days ago]
@seth Thanks for the response. We have large table use cases for which using in-memory rowstore will not be cost effective. Memsql documentation states " Inserts into a columnstore index will either go into the rowstore-backed or create a new columnstore-backed row segment." . I was hoping that insert into rowstore-backed would be fast as data would be less than 16 MB. Please let me know if I am missing anything.Thanks.