Hi everyone!!
I would like to hear your thoughts about.
A good way to delete a large number of rows from one rowstore or columnstore table?
For example, setting engine variables (such as logging) before executing a delete statement.
Is there a good use case for partitioning or backup a table?
Thank you very much.
Since MemSQL is a distributed system performance of deletes is amortized over all the nodes. Let’s us know if you have a specific use case where deletes are slow.
MemSQL doesn’t support partitioning in the Oracle sense. However you can cluster a columnstore table on a specific key and deletes that match this key would be very fast. If you share your use case we can help optimize it.