> 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 ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
