SQL Server Performance

Where to build business logic in db or web service

Discussion in 'General Developer Questions' started by vladimir_sim, Jan 19, 2006.

  1. vladimir_sim New Member


    Hi,

    It is regarding some issues on web application using ASP.NET and SQL2k. Some of my colleague argue that business logic should be build inside the DB while other argue it should be build in our web service server. I am confused which one is the better and correct way to go. Any method to determined where to build my business logic and how to build it. Next, how to make business logic build in flexible so that we can change the business logic on the fly without any compilation, just changing the logic either by script or logic save in the DB. Anyone with expertise in this area, please kindly advise and guide me. Thank a lot.
  2. satya Moderator

    I believe there is no easy way to implement business logic and some areas has to be compromised for the purpose of performance & tuning. I would suggest to test and deploy the methods on a test environment before applying to the production environment.

    Referhttp://www.sqldata.com/documents/logic.htm for information.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. vladimir_sim New Member

    Hi,

    Thank for your advise.
    Actually, I like to know whether we should have all our business logic build in the DB either by some special coding so that all logic in save in some tables or should we code our logic in the DB tables and have our web service server access the logic and apply it. And how do we do that. Any sample.
  4. satya Moderator

    As I said I'm not entirely sure about the process, but as it will be a good practice to involve other technologies such as web services or in any other language to have a independent logic, rather than dependant the whole logic on one system.

    When I had a chance at my end referred the above link for information, I'm sure you may get others response in this matter.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page