locked
database scaling RRS feed

  • Question

  • Hi,

    We have a 2 tier application;the business logic is in the stored procedure, the client uses ado.net to invoke the stored procedure and perform the operations.

    Now we have a requirement,where we need to support 13 networks in parallel.we would like to maintain only one set of procedure but we are ok with maintaining different tables for the 13 networks.

    So,we will create 13 instances with only the same tables on all of them,and then have a master database where the client connects to and invokes the stored procedure.Whenever a user logs into the system based upon his user name/ID we should use the appropriate table for his network by  creating a synonym dynamically per session,or a dynamic view or something like that.is that possible without bringing in a middle tier.If so how can it be done,

    Suggestion on the same are welcome.

    Thanks in advance.
    Thursday, October 16, 2008 11:42 AM

All replies

  • When you say "Netowork", what do you mean by that?

    To me it sounds like what you are after is a "Multi-Tenant" solution, you can read more on designing Multi-Tenant applications here:

    http://msdn.microsoft.com/en-us/library/aa479086.aspx

    Thursday, October 16, 2008 12:47 PM
  • Thanks for the suggestion.

    Network corresponds to an island geographically.We will install the system for 13 different groups of user residing on 13 different islands with the above mentioned approach.



    Thursday, October 16, 2008 1:02 PM
  • ok, then my suggestion is to look at designing you app after the Multi-Tenant pattern usggested in the article.
    Thursday, October 16, 2008 2:17 PM