pvignesh92
Honored Contributor

Hi @Matt User​. If I understand your question, you wanted to consider using Delta lake for your CRM database.

  1. Latency -> How much read and write latency are you expecting in Delta lake? The way data is organized in databases are much different than in Delta lake as the data will be sitting in different blocks in a cloud object store.
  2. Concurrency -> How many read and write transactions are you expecting to happen in the delta lake? Currently delta lake supports snapshot isolation for read I believe. How do you want your read and write to be isolated?
  3. Indexing -> There is no indexing or Primary key concept in Delta lake. Are you expecting some thing like this to speed up your searches?

There are many such areas that you need to explore before coming to a conclusion what you need to choose for this purpose. Hope this helps.