How to increase data insertion performance on SQL Azure

tapdata tapdata 0 Reputation points
2023-05-10T03:30:12.2533333+00:00

Hello, I have a data generator tool that consistently produces 10,000 records per second. I have an AzureSQL server installed on the Southeast Asia side, and despite being from China, I want to write 10,000 records per second on AzureSQL continuously. However, currently, I am only able to write 200 records per second. I am seeking advice on how to achieve a consistent write throughput of 10,000 records per second on SQL Azure, and would greatly appreciate any suggestions

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. Olaf Helper 40,576 Reputation points
    2023-05-10T05:49:52.05+00:00

    To increase performance depends on many factor.

    If you write the all the data from one client one by one record and you have a latency of 5 ms on your Internet connection (which would be pretty good), then with 200 records * 5 ms = 1000 ms then the latency already eats up the time.

    Consider to insert records batch wise, e.g. always 10 records at ones, which increase the pass througth already by factor 10.

    0 comments No comments