MicrosoftHi Sudhir Rawat , We have a synapse implemented for marketing automation and want to understand if it can support below use case
We have a sales event happening and a microservice is fired for every transaction. Inside the service, we can to fire a select statement to pick the associated Customer from a table with 50M customers. The "where clause" of the query will use a column with index (Unique Key).
The pick volume we are expecting is ~60 per second (3500/min) queries. Do you think Synapse is designed to handle that kind of load or we should look outside (any suggestion from Azure stack? CosmosDB?)
So basically it will be kind of "Select Col1.. From Customers where UID='ABCD'" fired at a rate of 60 sqls per second at pick.
