locked
make the relationship in between multiple table storage's tables will affect the performance RRS feed

  • Question

  • Hi,

    i'm going to develop business application,the product ID needs to be generic one and it should automatically generate the unique id(like identity in sql ) but,it has to be generate in formatted way 

    for example the ID would be "cityCode+areaCode+uniqueNumber" . here, cityCode and areaCode are going to maintain in separate table. while generate the product id, going to find the cityCode table and AreaCode table the generate  unique number by merge all the respective information.

    1) while doing all this will affect the performance Azure table storage performance and  web application ?

    2) making multiple relationship among multi-Table Storage will decrease the performance ?. 



    • Edited by Meraks Tuesday, November 4, 2014 4:42 AM edited texts
    Tuesday, November 4, 2014 4:36 AM

Answers

  • Hello,

    When you say tables, are referring to Azure Storage Tables or Relational Databases?
    Please note Windows Azure tables do not function in the same manner as tables in a relational database since they do not make use of relationships or have schemas.
    And if you are referring to relational databases, the latency in performance would depend on the logic used to generate the unique ID.
    You should be able to use the logic in an On-Prem SQL database and check for the latency.

    Regards,
    Malar.

    Tuesday, November 4, 2014 12:56 PM

All replies

  • Hi,

    Thank you for posting here.
    We are working on your query and will keep this thread updated with our findings / comments as the earliest.
    Appreciate your patience.

    Regards,
    Malar.

    Tuesday, November 4, 2014 12:09 PM
  • Hello,

    When you say tables, are referring to Azure Storage Tables or Relational Databases?
    Please note Windows Azure tables do not function in the same manner as tables in a relational database since they do not make use of relationships or have schemas.
    And if you are referring to relational databases, the latency in performance would depend on the logic used to generate the unique ID.
    You should be able to use the logic in an On-Prem SQL database and check for the latency.

    Regards,
    Malar.

    Tuesday, November 4, 2014 12:56 PM