Where to build business logic in db or web service | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Where to build business logic in db or web service


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.
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.
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.
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.
]]>