This is also useful in the case of normalised data stored in various tables.Īzure SQL Database and Hyperscale have very similar data ingestion speed. The data often here is stored in a de-normalised form with a schema.įor a high volume of small read and writes and smaller data loads, An Azure SQL database (General Purpose or Premium) can handle such tasks more efficiently. With this approach, complex jobs (queries or data load) are broken down into pieces and executed in parallel and enabling large data loads and complex queries to execute faster. Same here, please do some workload testing with those data lingestion processes and based on that you can choose the service tier which suits best for you, and compare hourly/monthly costs.Īzure Synapse is a great fit for the OLAP workload with set volume of reads and writes. Mathematically, velocity = distance/time as per Newton but in the laboratory you then see than in the real world friction is not considered on the formula. I am always hesitant to answer questions to other fellows at work without doing some tests first.
0 Comments
Leave a Reply. |