none
Performance comparison between Azure Table Storage and Azure SQL Database

    Question

  • Hi all,

    Just wanted to know purely on the merit of performance, which will be more performant - between Azure SQL Database and Azure Table Storage - considering the below cases.

    1. Data is present in a single table in a single partition.

    2.  Inserting rows (assume 2000)
    3.  Selecting rows resulting in one and multiple rows

    Regards, Saurabh

    Tuesday, December 27, 2016 4:15 AM

All replies

  • Hello Saurabh,

    Thank you for contacting Microsoft forums. We are pleased to answer your query.

    Azure SQL provides high-performance via multiple indices, normalized data structures etc. However, for the scenarios you’ve mentioned, using Azure Table Storage would be ideal in terms of performance plus it is a very cost-effective solution.

    Specifically for scenario no. 2 there's an interesting blog post about how using batching technique in Azure Table Storage for inserting multiple entities results in faster performance compared to using Azure SQL.  


    There is also a good comparison between Azure Table Storage and Azure SQL Database that helps you choose the right service depending on various business requirements. Hope this helps!

    Regards.

    Md. Shihab

    ***************************************************************************

    Please remember to click "Mark as Answer" on the post that helps you as this can be beneficial to other community members reading the thread. And vote as helpful.

    Tuesday, December 27, 2016 10:17 AM
  • These are my repeated measurements:

    SQL Database S2

    • store  7 ms per row, flat from 10k to 2M rows
    • query 3 ms per row, flat from 10k to 2M rows
     

    Data Table Storage

    • store 19 ms per row, flat from 10k to 2M rows
    • query  6 ms per row up to 500k rows, 21 ms per row up to 1.25M rows, 31 ms for 2M rows

    Results may be different, likely better, for a higher tier SQL Database.

    Data Table is the only Azure technology that shows significant deterioration of performance on larger rowsets.





    Tuesday, December 27, 2016 6:45 PM