Inserting into MemSQL columnstore tables


#1

Is there any general guidance around inserting data into memsql columnstore tables? I am designing a system which would ingest data into columnar tables. Given the nature of the load, we have end up having period of high update rate to the columnar table. Is there a possibility of degradation of performance of the MemSQL reads involving these tables? What kind of the problems could potentially crop up?


#2

Hi @sdevan

I am curious why you are choosing to use columnstore over rowstore? For your use case of ingestion + high update rate, rowstore seems to be the better option here. Here is some documentation on choosing rowstore over columnstore if that helps: https://docs.memsql.com/concepts/v6.7/columnstore/