I've often wondered about this is there really a need for a third tier, what would you put in the third tier that you *couldn't* put in a stored proc apart from file operations?
Thanks Kola > >-----Original Message----- > >From: Dave Watts [mailto:[EMAIL PROTECTED]] > >Sent: 03 April 2002 15:02 > >To: CF-Talk > >Subject: RE: Where is the best place to put business rules? > > > > > >> 1) Where is the best place to put the business rules? CF > >> Templates (using CFTransaction), or Stored Procedures (using > >> SQL Transactions). We realize that some business rules need > >> to reside on the templates, such as client side data validation. > >> But processing pages are a different story. > > > >In general, I think that stored procedures are better for any > >generic data > >manipulation tasks. Using stored procedures provides many > >advantages, such > >as more efficient processing and the ability to more easily replace or > >augment the presentation layer code. > > > >You did mention n-tier apps, and it's worth pointing out that in a > >three-tier app, the things you generally think of as "business > >rules" would > >be implemented in the middle tier, between the presentation > >layer code (CF, > >in this case) and the database. However, to the extent that your business > >rules are data manipulation issues, you're better off putting them in the > >database tier of your two-tier application. > > > >> 2) What is more likely to need clustering - the Web/CF Server, > >> or the SQL Server. > > > >The web servers are more likely to benefit from clustering, in general. > > > >Dave Watts, CTO, Fig Leaf Software > >http://www.figleaf.com/ > >voice: (202) 797-5496 > >fax: (202) 797-5444 > > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
