Sample Code Database in Windows Azure RRS feed

  • Question

  • Hi all,

    for our our client, I should develop a small sample application for the cloud.

    Today we have a database in which codes are stored. The database growth heavily, at the moment we have 250 Million rows in one table.
    Therefore I want to implement a windows azure based service which will generate new codes, store the codes and a webservice which will
    get back the codes to a client application. The codes are formated in numeric and alphabetical manner with a lenght off 13 characters, sample: "123GH45SD788".

    So my question is, how you would implemt the solutation: SQL Server Azure, partitioning and then how to save the code in the partition tabels for best performnace.

    Thanks for all answers.


    Thursday, January 14, 2010 10:40 AM